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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ContabilidadBI
Helper III
Helper III

Last year comparison for multiple different measures?

Hi friends,

 

I am building a financial model with lots of different measures, and for every measure, I need to compare it with the same one last year, both in absolute and relative terms.

 

So for every measure, I am creating:

- the measure

- the measure last year (with PREVIOUS YEAR())

- Measure VAR = [measure] - [measureLY]
- Measure VAR% = DIVIDE ([measure VAR]; [MeasureLY])

 

For every indicator, ratio.... (and they are a lot!) I have to create thoes 4 different measures. Is this the correct way to go? I am relatively new in Power BI and I was thinking that maybe there is a better alternative, like a pattern that can be applied to different measures to get the difference between that measure and the same measure last year, without the need to create all this measures everytime. Is there a better alternative or I am doing it the right way?

 

Thank you!!

5 REPLIES 5
Anonymous
Not applicable

did anyone solve this, I'm having the same question

v-juanli-msft
Community Support
Community Support

Hi @ContabilidadBI

In your screenshot, which are measures?

The columns [2013],[2014]? or the lines ?

 

Best Regards

Maggie

Hi Maggie, and sorry for the incredible delay, I was in another country.

 

The measures are the lines, the ones in lowercase.

 

Thank you.

CheenuSing
Community Champion
Community Champion

Hi @ContabilidadBI

 

Please upload some sample data and the output expected to Googledrive or Onedrive and share the link here to find a solution.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

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:

 

jggfhhf.png

 

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:

 

fssdfsdfdfs.png

 

So measures are grouped in two categories in this case.

 

Thank you!!!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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