Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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.