Forum Discussion
Calculate the variance between two (variable) selections
I have this simplified view: As you can see now LBE1 and LBE2 are selected. I want to ad a 3rd field (measure) which will give the variance between the selections. The slicer on the right is...
Maybe posting the underlying data will help to get this solved.
| Year | Mth | Type | Addendum |
| 2024 | 1 | LBE1 | 340635 |
| 2024 | 1 | LBE2 | 275680 |
| 2024 | 2 | LBE1 | 290012 |
| 2024 | 2 | LBE2 | 287260 |
| 2024 | 3 | LBE1 | 314827 |
| 2024 | 3 | LBE2 | 298206 |
| 2024 | 4 | LBE1 | 283520 |
| 2024 | 4 | LBE2 | 321729 |
| 2024 | 5 | LBE1 | 270133 |
| 2024 | 5 | LBE2 | 319776 |
| 2024 | 6 | LBE1 | 259413 |
| 2024 | 6 | LBE2 | 319392 |
| 2024 | 7 | LBE1 | 256339 |
| 2024 | 7 | LBE2 | 272356 |
| 2024 | 8 | LBE1 | 233174 |
| 2024 | 8 | LBE2 | 252100 |
| 2024 | 9 | LBE1 | 273970 |
| 2024 | 9 | LBE2 | 286258 |
| 2024 | 10 | LBE1 | 264020 |
| 2024 | 10 | LBE2 | 253540 |
| 2024 | 11 | LBE1 | 257562 |
| 2024 | 11 | LBE2 | 257523 |
| 2024 | 12 | LBE1 | 222870 |
| 2024 | 12 | LBE2 | 223364 |