Display the Number of Days Between Report Dates

[PaulBethancourt]

I'm trying to find the number of days between 2 dates (the Report_Date and the prior Report_Date).

This seems simple but it's eluding me.

[PaulBethancourt]

Thanks Bifinity_75.  It is throwing up an error:

[Bifinity_75]

Hi @PaulBethancourt, try this calculate column:

Days = 
var PreviousDate = 
MAXX(FILTER(ALL('Table'),EARLIER('Table'[REPORT_DATE]) > 'Table'[REPORT_DATE]),'Table'[REPORT_DATE])
Return
if (PreviousDate<>0,'Table'[REPORT_DATE]-PreviousDate,0)

The result:

Best Regards

[PaulBethancourt · Accepted solution]

This worked for me

Days =

Var PreviousDate =

calculate(max('SCM_RMA_METRICS'[Report Date Full]),filter(all(SCM_RMA_METRICS),SCM_RMA_METRICS[Report Date Full]<earlier(SCM_RMA_METRICS[Report Date Full])))

return

If(PreviousDate<>0,SCM_RMA_METRICS[Report Date Full]-PreviousDate,0)

[PaulBethancourt]

Days =

var PreviousDate =

MAXX(FILTER(ALL(SCM_RMA_METRICS),EARLIER(SCM_RMA_METRICS[REPORT_DATE]) > SCM_RMA_METRICS[REPORT_DATE]),SCM_RMA_METRICS[REPORT_DATE])

Return

if (PreviousDate<>0,SCM_RMA_METRICS[REPORT_DATE]-PreviousDate,0)