Forum Discussion
DATEDIFF
I am currently trying to calculate some ratios, and I need to restrict certain data depending on the number of days between my min and max date. The mindate and the maxdate generally span across year...
Hi,
Assuming Year and Month name in your visual have been dragged from the Calendar Table, write this measure
Days passed by = max(calendar[date])-min(calendar[date])+1
Format this measure as a whole number.
Hope this helps.