cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent 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
Highlighted
Microsoft
Microsoft

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

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

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

View solution in original post

Highlighted
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.

Highlighted
Anonymous
Not applicable

Re: How to add delta between columns

Hi, did you ever get this properly resolved?

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors