Forum Discussion
year over year variable
Trying to create an easy year over year growth chart but not finding any really simply charts Would love to show it on a water fall chart Also not easy to find calculation for year over year ...
In your provided information, your formula should work.
It doesn't error out it just shows up blank
Hi Anonymous,
Would you please provide more information about "it just shows up blank"?
To calculate difference among each year. You can create a calculated table group by the year and create a calculated column to return the previous year amount for each row, then create another calculated column to return difference. I have created a sample .PBIX file for your reference, you can take a look it to check if it can meet your requirements.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
