Hi all,
I've got a question regarding the possibility, or not, to be able to automaticaly calculate a difference between values of a same row.
Here's an example of what I'm expecting to do:
The data (one unique table):
Month Value Indicator
1 100 toto
1 50 toto
2 120 toto
2 75 toto
3 30 toto
3 36 toto
3 80 toto
...
The report would look like this:
Indicator Month Value Month Value Diff.
Toto 1 150 2 195 +45
Then I'd like to be able to change the months selected and always have the difference calculated.
Is it possible to preset the formula calculation with DAX ?
TIA
I've got a question regarding the possibility, or not, to be able to automaticaly calculate a difference between values of a same row.
Here's an example of what I'm expecting to do:
The data (one unique table):
Month Value Indicator
1 100 toto
1 50 toto
2 120 toto
2 75 toto
3 30 toto
3 36 toto
3 80 toto
...
The report would look like this:
Indicator Month Value Month Value Diff.
Toto 1 150 2 195 +45
Then I'd like to be able to change the months selected and always have the difference calculated.
Is it possible to preset the formula calculation with DAX ?
TIA