Forum Discussion
How to add delta between columns
Hi,
I have a report needs to add delta of revenue& profit between each year. anyone can help?
here is a sample of what I need.
thank you
Eric
Based your description, you need to calculate the difference between two columns in Matrix, right?
Currently, there is no such a functionally to achieve this requirement directly. To workaround it we can create calculated measure, here is a similar issue for you reference.
https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185Regards,
Charlie Liao
3 Replies
v-caliao-msftMicrosoft Employee
Based your description, you need to calculate the difference between two columns in Matrix, right?
Currently, there is no such a functionally to achieve this requirement directly. To workaround it we can create calculated measure, here is a similar issue for you reference.
https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185Regards,
Charlie Liao
Hello v-caliao-msft
Is there a possibility to create a flexible delta? As an example, instead of always comparing January x February, I want to have the freedom to select a month in a slicer and then the delta would be calculated.
The way here mentioned allows me to have a measure with a specific month inside, but I didn´t find a way to have this flexibility on it.
Thank you in advance.
