Compare values based on date filter

[joe_2802]

Apologies for a possibly dumb question and thanks in advance:

I require to create two tables based on the data both with indepedent date filters. So far, so good.

I need a third table however, that gives me the change in carrots and percentage dynamically based on the respective date filters of the two tables. For example:

Report 1:

Date	Category	Carrots	Percentage
02.03.2017	Donald	2.630.266.580	81,59
02.03.2017	Bugs Bunny	113.204.133	3,51
02.03.2017	Micky	190.531.016	5,91
02.03.2017	Goofy	186.729.246	5,79
02.03.2017	Mini	53.912.554	1,67
02.03.2017	Richy	48.941.252	1,52

Report 2:

03.03.2017	Donald	2.631.032.714	81,62
03.03.2017	Bugs Bunny	115.348.212	3,58
03.03.2017	Micky	186.748.748	5,79
03.03.2017	Goofy	186.875.553	5,80
03.03.2017	Mini	54.630.154	1,69
03.03.2017	Richy	48.949.397	1,52

How can I report 3 have dynamically calculate based on the respective filters so I can add it to my dashboard?

Report 3:

Category	Change in Carrots	Change in Percentage
Donald	766.134	0,02
Bugs Bunny	2.144.080	0,07
Micky	-3.782.267	-0,12
Goofy	146.308	0,00
Mini	717.600	0,02
Richy	8.146	0,00

Thanks so much!

[v-danhe-msft]

Hi @joe_2802,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @joe_2802,

Based on my test, you could refer to below steps:

Add index columns for your tables:

Merge your two tables as new table

Create customer columns in new table and remove the other columns:

Result:

You could also download the pbix file to have a view

https://www.dropbox.com/s/x52kamo1ygkq1qv/Compare%20values%20based%20on%20date%20filter.pbix?dl=0

Regards,

Daniel He