Date Picker - Difference in sales between 2 tables

[EstherBR]

Hi,

I have created 2 tables with 2 date pickers. I would like to create a 3rd table that calculates the difference in sales between the 2 tables. 

I created the day picker by creating a slicer with settings "Before" and I added a Top N 1 filter to the table.

How can I create a 3rd table that calculates the difference in sales?

This is the data model:

I am using the calendar and calendar 2 date tables for the slicers and the matrix.

Thank you so much,

Esther

[elitesmitpatel]

please share the pbix file and expected output

[EstherBR]

@elitesmitpatel , You can download the file in this link: https://drive.google.com/file/d/1jmdHdWu4FfWu_jm5AbX8M_CWHk1OH3ek/view?usp=drive_link

I don't have the option to attach a file in this post.

[v-junyant-msft]

Hi @EstherBR ,

Allow me to inquire if you have solved your problem? The file in the link you provided shows that it has been deleted:

If you have already solved it, please accept the reply as solution if you find it useful, or please provide your solution so that more users facing the same problem can find it faster.

Best Regards,
Dino Tao

[elitesmitpatel]

you are not following the right way to matching with date .please improve it .and please tag other people for help .
thank you