Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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/188185
Regards,
Charlie Liao
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/188185
Regards,
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.
Hi, did you ever get this properly resolved?
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |