Cumulative MOM total of average

[gauravnarchal]

Hello - I need your help to show the cumulative MOM Average total.

Average is SUM of Column A + B + C + D + E

Table 1

Month	A	B	C	D	E
Jul-21	330	300	416	521	379
Aug-21	365	335	451	556	414
Sep-21	400	370	486	591	449
Oct-21	435	405	521	626	484
Nov-21	470	440	556	661	519
Dec-21	505	475	591	696	554
Jan-22	540	510	626	731	589

Result

[amitchandak · Accepted solution]

@gauravnarchal , Try a measure like this with date table

Cumm = CALCULATE(averageX(values('Date'[Month Year]),calculate(Sumx(Table, [A]+[B]+[C]+[D] +[E]))) ,filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.