Forum Discussion
Month-to-Month Change With Multiple Values
Hi
you need a common Date table, to use PREVIOUSMONTH
total =SUM (value)
value_percent =
var a = SELECTEDVAUE (attribute)
return SWITCH (a,
"A", blank(),
"B", total / CALCULATE (total, REMOVEFILTER (attribute), attribute = "A", PREVIOUSMONTH (Date)),
"C", total / CALCULATE (total, REMOVEFILTER (attribute), attribute = "B", PREVIOUSMONTH (Date)),blank() )
Creata Matrix with month and attribute like you show, and add "value_percent' as value
Hello Anonymous , thank you very much for your answer.
However my main difficulty is that I would like to have a measure that works no matter which attribute is chosen, not only for B/A.
That is to say, a measure capable of producing the following result:
| A | B | C | |
| July | B/A | C/B |