Line Burn Up Chart Running Total 3 Date Column Count

Super User

3 years ago

DBKAHUNA88 , first of all you have join all these dates with one date table and have this date range column there, I think week's start and end date

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

Week name = [Week Start date] & " - "& [Week End date]

Only one join will be active. So create measure using userelationship for inactive join

M1= calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date]))

First create measure then create cumm on these meausres

example

Cumm Sales = CALCULATE([M1],filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE([M1],filter(allselected(date),date[date] <=max(date[Date])))

You can also consider window function

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

Forum Discussion