Forum Discussion
Solved
Cumulative Graph Troubles
Hello Trying to make a cumulative graph that shows data up till the last month, leaving the future months blank, however ran into trouble of disappearing data The one 'grey' in July should be vi...
Hi, not sure if you did had the solution but to remove the futur months use the suggestion from Ashish_Mathur but CONCATENATE the dates:
Measure =
VAR currentMonth =
CONCATENATE(YEAR(TODAY()), FORMAT(TODAY(), "MM"))
VAR monthNo =
FORMAT( MAX('T_BASS_DIM_DATE (Jobs)'[Date]),"YYYYMM" )
RETURN
IF ( monthNo <= currentMonth, [Cumulative To End of Year], BLANK() )
Regards KeepCalm007
Anonymous