DATEDIFF

[Anonymous]

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

Days Since Solution Fit Stage = CALCULATE(DATEDIFF(EOMONTH([MinDate],0), [MaxDate],DAY)), the difference is 0 because when expanded to months, the context changes and EOMONTH(mindate) and max date become the same. 

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. 

[Ashish_Mathur]

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.

[lbendlin]

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-...
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/1447...