Need Help with DAX to calculate variance between two matrixes

[nwiltshire]

hi, I need help calculating variances between two matrixes in power BI where both matrixes are from the same table .

my Table is called Forecast as below 

Key	Created on	FY Year	Fy Month	FCST Value
1	1/01/2023	2024	1	$            500.00
2	10/01/2023	2024	1	$            600.00
3	10/02/2023	2024	1	$            100.00
4	12/02/2023	2024	1	$            200.00
5	5/03/2023	2024	2	$            700.00
6	10/03/2023	2024	2	$            500.00
7	20/03/2023	2024	2	$            600.00
8	30/03/2023	2024	2	$            200.00
9	9/04/2023	2024	2	$            100.00

I have 3 slicers - one for selecting two different creation date and one for selecting FCST FYYear and month 

in the first slicer user selects : 10/01/2023

in the second slicer user selects : 12/02/2023

and in the 3rd slicer they ask to see what they have forcasted on above two dates for JAN 2024

two different matrixes will show them the results (should this be in one matrix?) 

the result of the matrixes are as below: 

1st: 

10/01/2023

2024

1

$  100.00

2nd matrix:

12/02/2023

2024

1

$  200.00

I need to have a 3rd matirx that shows the variance, for thsi example the variance is $100

is this possible via one table? or do I need two tables? 

Appreciate your help.

[lbendlin]

Are you planning to do this with a data model or with a bunch of disconnected tables? Instead of the first two slicers you could use one "Between" slicer.

[nwiltshire]

there is only one table which has all the data, all the creation dates and all the forecasts 
I tried the Between slicer , but users want to see the results on two exac dates not in between dates. 

thanks