New Table / Measures from two existing identical tables

[Gazsim44]

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

[amitchandak]

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]

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, 

[amitchandak]

Please share some sample data

[Gazsim44]

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,