I have a measure like this:
Days Change Previous Report = VAR vThisCompDate = MIN ( Backlog[End Date (Ops)] ) VAR vThisReportDate = MIN ( Backlog[Report Date] ) VAR vPrevCompDate = CALCULATE ( LASTNONBLANKVALUE ( Backlog[Report Date], MIN ( Backlog[End Date (Ops)] ) ), ALLEXCEPT ( Backlog, Backlog[Project], Backlog[Customer], Backlog[Job Site] ), Backlog[Report Date] < vThisReportDate ) VAR DaysDiff = DATEDIFF ( vPrevCompDate, vThisCompDate, DAY ) RETURN DaysDiff
However, it doesn’t sum correctly the days of difference, please see below screen. Does anyone know how to fix it?
Here is the pbix file, I have created a new “fake” dataset. However, it seems that the days are not added at all now.
My goal would be to see the total days of difference, which will help me to understand what was the total days difference by customer (for example).
Pbi_dset.pbix (85.2 KB)