Forum Discussion
12-month rolling calculation with another moving date variable (Second Attempt - More Description)
Hi Folks, Using September 2021 RS desktop. I'm trying to build a measure for 12-month rolling costs, which seemed to work out. CostR12 =
Var SelectedMaxDate = MAX ('Claims Costs Transa...
Hi Ashish,
Here's a link for the .pbix file I'm working with.
https://drive.google.com/file/d/1pJ-66sbkMXtZs6eM_3-xpHhcrqRrnyqJ/view?usp=sharing
Ashish_Mathur
Super User
Super UserYour CostR12 measure can be simplified (even though that may be giving you the correct answer). Please explain what you want to calculate via that measure. Then we will go to answering your actual question asked.