deviation (%)
1 TopicDeltas within a Measure (?)
Hello all, again, I need help because I am totally lost: with the help of this forum, I was able to create this chart, and there is now only missing, to show the deltas between the periods (-15% between 2020 and 2021 i.e.). But I do not have an idea, how to calculate it, because to be able to create that chart, I have the values in one measure: YaQ_Volume = SWITCH( SELECTEDVALUE('Unrelated Date'[Category]), "Year",CALCULATE([SalesFinal],FILTER(VALUES(Output[Yr]),FORMAT(Output[Yr],"#")In VALUES('Unrelated Date'[Period]))), "Quarter",CALCULATE([SalesFinal],KEEPFILTERS(TREATAS(VALUES('Unrelated Date'[Period]),Output[QYear])), KEEPFILTERS(Output[Yr]=MAX(Output[Yr])))) Is there a way to insert now also the deltas between the periods? Thank you for any tipp and advice.Solved517Views0likes2Comments