Difference to the column next to the other

[morizf]

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.

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

[lbendlin]

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.