cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gazsim44 Frequent Visitor
Frequent Visitor

New Table / Measures from two existing identical tables

Hi All, 

 

I currently have a setup of two 'identical' tables in which the only difference is they are operated by different slicers for the purpose of month and year comparison.

 

I would now like to if possible create a third 'comparison' table which would have the same columns but in effect would just display the difference between the values shown in these two existing tables.

 

So for example Table A has a Revenue of $1000 (set for say July 2019) and Table B has a Revenue of $1500 (set for July 2018) so the final table would display a value of -$500 in Revenue because 2019 is less than 2018.

 

Many thanks, 

Gaz

4 REPLIES 4
Super User IV
Super User IV

Re: New Table / Measures from two existing identical tables

Use INTERSECT and if required summarized inside it. 

INTERSECT(Summarize(A, COl, ) ..., Summarize(B, COl, ) )

 

You can use this as a table or has Var in your formula to calculate the difference.

 

Gazsim44 Frequent Visitor
Frequent Visitor

Re: New Table / Measures from two existing identical tables

Hi and many thanks for the response.

 

However I have to admit I am complete novice with this functionality and dont even know where to begin - could you possible advise some further assistance?

 

Thanks, 

 

Super User IV
Super User IV

Re: New Table / Measures from two existing identical tables

Please share some sample data

Gazsim44 Frequent Visitor
Frequent Visitor

Re: New Table / Measures from two existing identical tables

Hi, I don't unfortunately have any sample data and naturally I can't share the actual data involved.

 

I have however just attached a sample of the top line of one of the visuals so hopefully you can get an understanding.

 

Each visual is identical other than that they are operated by seperate month and year slicers. The data table or source for both these visuals is identical, I am literally just displaying different numbers by changing the slicers.

 

The idea would be as I have done in excel in the past to then add some sort of calculated table that would display the difference between these two visuals as selected by the slicers.

 

Thanks, Capture.PNG

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors