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
morizf
Frequent Visitor

Difference to the column next to the other

Hello,

i would like to know if there is a smart way to give the difference to the column next to the other column without a measure.

 

morizf_0-1689926086005.png

i would like to keep the visual dynamic and to choose a year and showing the +/- differences to the previous year. In a measure i have to give the year in the calculate formular. For example if you only have the year 2018+2019 selected, i want to show the difference in another table. If you add 2020 then the differences 2019->2018 and 2020->2019

 

Thanks in advance

1 REPLY 1
lbendlin
Super User
Super User

the column next to the other column

Power BI has only a very faint idea of what you mean by that.  The newly introduced Windowing functions can help you to describe what you want.  They do require measures, though.

Helpful resources

Announcements
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.

Top Solution Authors
Top Kudoed Authors