Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
This worked for me
Thanks Bifinity_75. It is throwing up an error:
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
This worked for me
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |