Forum Discussion
Rolling Sum between two dates
kasiaw29 , please refer if this way can help
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.new table approch
Tables
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
kasiaw29 , please refer if this way can help
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
new table approch
Tables
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
Hey amitchandak
Had to modify it slightly so that it worked with what I was trying to measure but your article was 100% correct! Thank you!My measure, in the end, looked like this:
Measure =CALCULATE(SUMX(SUMMARIZE(FILTER(CROSSJOIN('Customer Order Dates','Calendar'),'Calendar'[Day] >= 'Customer Order Dates'[Date Entered] && 'Calendar'[Day] <= 'Customer Order Dates'[Invoice Date]),'Customer Order Dates'[Date Entered],'Customer Order Dates'[Invoice Date], 'Customer Order Dates'[Booked Value]),'Customer Order Dates'[Booked Value]))
