Compare calculate the difference according to the date selected in 2 tables

[EsterBR]

Hi,

I have the following tables with date slicers and 2 different dates selected. I would like to create a measure that shows the difference in sales between the tables. the result shoud be 2 (1001-1003). How can I achieve that? Thank you so much!

[v-tianyich-msft · Accepted solution]

Hi @EsterBR ,

I made simple samples and you can check the results below:

Measure 2 = var _s1= SELECTEDVALUE('Table 2'[Date])
var _s2= SELECTEDVALUE('Table 3'[Date])
RETURN SUMX(FILTER('Table',MONTH([Date])=MONTH(_s1)),[Value]) - SUMX(FILTER('Table',MONTH([Date])=MONTH(_s2)),[Value])

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @EsterBR 
Please refer to my solution in the linked discussion, it includes a pbix to follow :

https://community.fabric.microsoft.com/t5/Desktop/Dynamic-comparison-with-two-slicers/m-p/3847255#M1...

you should apply the same logic on date tables.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[EsterBR]

Hi @Ritaf1983, Thanks for the answer but unfortunately I cannot create the same data model in my dashboard.