Forum Discussion
Dynamic Measure Selection and YOY Calculation
Hi,
Yes, you will have to write that formula for each measure.
Hi,
Assuming you have:
- A Calendar Table with a Month and Year column
- A relationship from the Date column of yoru data table to the Date column of your Calendar table
- Dragged Year and Month from the Calendar table into your matrix visual
you should be able to use measures such as
YoY = [Amount]/CALCULATE([Amount],SAMEPERIODLASTYEAR(Calendar[Date]))-1
where Amount is a measure such as =SUM(Data[Total Sales])
Hope this helps.
Hi,
Once again thank you for your response. I think I maybe making the question more complicated that it has to be. Essentially I am just trying to see how to filiter the measures(about 30) in the format seen above(the first table filter that row). I think I've got the YOY calculation, but just to be sure For the YOY calculation do I have to right that for each measure? Where Amount= SUM(Sales[Data]))
SUM(Sales[Quantity)...
etc...
Hi,
Yes, you will have to write that formula for each measure.
Great! I know where to go from there. In terms of filtering the measures would you be able to provide a little more insight as how to that works. I went through the previous suggested solution and was not able to filter the measures. Once again thank you for your help! This has been a big road block in using measures for advanced calculations and measures.