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:
2nd matrix:
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.
