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 ) )
Jihwan_Kim
Super User
4 years agoHi,
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
)
)ElenaJ
4 years agoFrequent Visitor
It worked! Amazing!
Many thanks for your help!