Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
common763
Helper III
Helper III

Matrix Table Difference Between two dates with non-date values

I have a matrix table with VALUE A.  I have it filtered to show the last two days of the data.  Below is what it looks like.

 

7/14/2020        7/13/2020

20                     25

 

Both numbers are from one specific selection called Active. 

 

I want to subtract Active (7/14/2020)  - Active(7/13/2020) and have the difference shown next to the two dates.

 

Is there an easy way to do this?  I am having a problem getting this done.

1 REPLY 1
lbendlin
Super User
Super User

you cannot show the difference "next to the values" in the same visual. You can create a measure that shows the difference as a new value in the second row (or stacked if you select "show values on rows". You will get two differences, one valid one and one empty one.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.