Forum Discussion
Initial/final balances with measures
Hi,
Let´s say I have the following table with movements,
| Group | Source | Movements | Date |
| DE | Budget | 5 | 05/01/2023 |
| DE | Budget | -2 | 15/01/2023 |
| DE | Budget | 3 | 06/02/2023 |
| DE | Budget | 10 | 04/03/2023 |
| DE | Budget | -3 | 20/04/2023 |
| DE | Budget | 9 | 10/05/2023 |
| DE | Budget | -7 | 20/05/2023 |
| DE | Budget | 4 | 25/05/2023 |
| UK | Budget | 10 | 02/01/2023 |
| UK | Budget | -3 | 15/02/2023 |
| UK | Budget | -5 | 06/03/2023 |
| UK | Budget | 7 | 15/03/2023 |
| UK | Budget | 5 | 20/03/2023 |
| UK | Budget | 2 | 10/04/2023 |
| UK | Budget | -6 | 22/05/2023 |
| UK | Budget | -2 | 22/05/2023 |
| DE | V2 | 15 | 05/01/2023 |
| DE | V2 | -3 | 15/01/2023 |
| DE | V2 | 3 | 06/02/2023 |
| DE | V2 | 16 | 04/03/2023 |
| DE | V2 | -6 | 20/04/2023 |
| DE | V2 | 9 | 10/05/2023 |
| DE | V2 | -7 | 20/05/2023 |
| DE | V2 | 6 | 25/05/2023 |
| UK | V2 | 8 | 02/01/2023 |
| UK | V2 | -1 | 15/02/2023 |
| UK | V2 | -6 | 06/03/2023 |
| UK | V2 | 7 | 15/03/2023 |
| UK | V2 | 5 | 20/03/2023 |
| UK | V2 | 3 | 10/04/2023 |
| UK | V2 | -6 | 22/05/2023 |
| UK | V2 | -4 | 22/05/2023 |
And another table with the initial balances
| Group | I. Balance | Date |
| DE | 100 | 01/01/2023 |
| UK | 50 | 01/01/2023 |
I need to get a matrix where I can select the version of the movements to be included, so the Final/initial balances change. Somehting like this:
If I select Budget:
| BUDGET | |||||
| January-23 | February-23 | March-23 | April-23 | May-23 | |
| I. Balance | 150 | 163 | 163 | 180 | 179 |
| Variation | 13 | 0 | 17 | -1 | -2 |
| F. Balance | 163 | 163 | 180 | 179 | 177 |
If I select V2:
| V2 | |||||
| January-23 | February-23 | March-23 | April-23 | May-23 | |
| I. Balance | 150 | 170 | 172 | 194 | 191 |
| Variation | 20 | 2 | 22 | -3 | -2 |
| F. Balance | 170 | 172 | 194 | 191 | 189 |
I was able to calculate a table but the I caanot make the choice of the movemetns version from a slicer. How can I do this with measures so it reacts to the chosen version in the canvas?
Thanks,
No RepliesBe the first to reply