topic Re: cummilative line graph using Rolling 30 days in DAX Commands and Tips

cummilative line graph using Rolling 30 days

VikramAdi — Wed, 08 Mar 2023 13:56:08 GMT

Hi All,

Currently i have calculated Rolling 30 days average , i want to display Rolling 30 days cummilitive amount.

Thanks,

VAdi

Re: cummilative line graph using Rolling 30 days

Jihwan_Kim — Tue, 07 Mar 2023 05:21:23 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below and the attached pbix file.

Cumulative Measure = VAR __Date = MAX ( 'Date'[Date] ) VAR __Table = ADDCOLUMNS ( DATESINPERIOD ( 'Date'[Date], LASTDATE ( 'Date'[Date] ), -30, DAY ), "__30Avg", [Rolling 30 Days Average] ) VAR __Result = SUMX ( __Table, [__30Avg] ) RETURN __Result

Re: cummilative line graph using Rolling 30 days

VikramAdi — Wed, 08 Mar 2023 13:56:44 GMT

Thanks for the responce