Forum Discussion
Last year comparison for multiple different measures?
Please upload some sample data and the output expected to Googledrive or Onedrive and share the link here to find a solution.
Cheers
CheenuSing
- ContabilidadBI7 years agoHelper III
Hi!, thanks for your answer.
I have a model with many many measures, and for every measure, I need to show the variation between years. So for example I have this measures:
And to show the variation with the previous year, I have to calculate:
the measure
the last year measure
the Varmeasure= [measure] - [LYmeasure]
VAR%= Varmeasure/LYmeasure
And what I would like to do is a way to create a measure that calculate the variation with that measure Last Year, so I can use always the same measure, not to create a Var measure for every measure... I don't know if I am explaining myself clearly. Imagine that thoes measures in the rows are a rows of a table (instead of measures), so in that case I would be able to do what I want with only one measure, because depending on the filter context, the measure would calculate a different number. Is there a way to do something like that but for measures instead of values of tables?
Also a way to group measures to show them in a hierarchy would be very nice (not to group them in the model to organize, but to show them like this:
So measures are grouped in two categories in this case.
Thank you!!!