Forum Discussion
Calculating Between 2 dates over 2 months
pbreslin24 , I made a similar attempt in past, see if the attached pbix can help
or this blog
How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
pbreslin24 , I made a similar attempt in past, see if the attached pbix can help
or this blog
How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
This saved my day, thank you amitchandak!
I have a followup question to this. How would one using your soulution:
Day by Month = CALCULATE(countx(SUMMARIZE(filter(CROSSJOIN('Data','Date'),'Date'[Date] >= 'Data'[StartDate] && 'Date'[Date]<= 'Data'[EndDate]),'Data'[id],'Date'[Date]),'Date'[Date]))Calculate the value accumulated?
It works perfect specifying the number of days in each month but I need to vizualise the values accumulated over a year and I can't get it to work.