cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ericbi Regular Visitor
Regular Visitor

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. 

 

Capture.JPG

 

thank you

Eric

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: How to add delta between columns

@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

2 REPLIES 2
Moderator v-caliao-msft
Moderator

Re: How to add delta between columns

@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 Frequent Visitor
Frequent Visitor

Re: How to add delta between columns

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.