Forum Discussion
Month-to-Month Change With Multiple Values
- Anonymous4 years ago
- 4 years ago
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
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