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 years. When I try to calculate
Example: If I choose a period between April 2021 to March 2023, I would like to be able to calculate the difference between the two dates and not beginning of April to End of April.
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi,
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.
