Showing results for 
Search instead for 
Did you mean: 
STG_Michael Frequent Visitor
Frequent Visitor

Dynamic Rolling Measures

Good Afternoon!


I am needing to create some rolling calculations for a lot of measures... at least 75... closer to 100.

Below is a screenshot of some examples.

A few questions:

  1. Do I have/need to create a measure for each rolling measure... including Current Month, Prior Month, YTD?
  2. Is there a way to make it so I don't have to do #1?




- Michael

Annotation 2019-09-19 121121.png

Community Support Team
Community Support Team

Re: Dynamic Rolling Measures

Hi STG_Michael,

If you want to show current month, prebious Month, R3M, R6M  in table at the same time, I think you need to create measures for each rolling calculations.


Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

STG_Michael Frequent Visitor
Frequent Visitor

Re: Dynamic Rolling Measures

There's got to be a better way to do this.

Otherwise, I am creating hundreds and hundreds of measures...

Helpful resources

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 47 members 982 guests
Please welcome our newest community members: