Forum Discussion
Solved
Dynamic Measure calculation using other Dynamic Measures and Filters
I have a created a measure table to to enable metric selection in visuals. The table Measure_Select looks like this MEASURE Measure 1 Measure 2 I am using this table to create a Measur...
I am not quite sure why it is working now but somehow it does:
Calc MoM YoY = Calculate(Measure_Select[Select A Measure],Period[Period]="ThisMonth")/Calculate(Measure_Select[Select A Measure],Period[Period]="MoM LastYearToDate")-1
For some reason Calculate accepts the calculated measure now...
Hi toulou what about using a Period Table, which will make it easier to create the custom periods that you are after?
And then you can use your periods to easily create the calculations you require also?
I am certain that you can the simply use the Period Names to Dynamically Filter?