How to add delta between columns

[ericbi]

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

[v-caliao-msft · Accepted solution]

@ericbi,

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

[Frederico]

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.

[Anonymous]

Hi, did you ever get this properly resolved?