Forum Discussion

morizf's avatar
morizf
Frequent Visitor
3 years ago

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.

 

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago
    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.