Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
STG_Michael
New Member

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?

 

Thanks!

 

- Michael

Annotation 2019-09-19 121121.png

2 REPLIES 2
dax
Community Support
Community Support

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.

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.