Forum Discussion
ElenaJ
4 years agoFrequent Visitor
Running Total with Blank Month Value
Hi, I created a measure for a running total by month, the coding used is: Cumulative = CALCULATE( SUM('Schedule'[Forecast]), USERELATIONSHIP(CalendarM[Date],'Schedule'[Forecasted Date...
- 4 years ago
Hi,
Thank you for your feedback.
Please check the below if it suits your requirement.
-Jun value shows in the table visualization
-only upto Nov values are shown.
Cumulative = VAR _lastdateinscheduletable = CALCULATE ( MAX ( Schedule[Forecasted Date] ), REMOVEFILTERS () ) RETURN CALCULATE ( SUM ( 'Schedule'[Forecast] ), USERELATIONSHIP ( CalendarM[Date], 'Schedule'[Forecasted Date] ), FILTER ( ALLSELECTED ( 'CalendarM' ), CalendarM[Date] <= MAX ( CalendarM[Date] ) && CalendarM[Year] = MAX ( CalendarM[Year] ) && MIN ( CalendarM[Date] ) <= _lastdateinscheduletable ) )
Anonymous
4 years agoNot applicable
ElenaJ
4 years agoFrequent Visitor
Sure. I created a ten year calendar table called calendarM (2020-2030) and linked it to my fact table schedule. Calendar M has date and month/year columns.