Deltas 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.
Measure showing deviation (%) (timestamps in datainput are within one field)
Hi, I have datainput in a special structure and I want to keep this structure The timestamp per period in datainput is within one field. Is there a possibilty to create a measure to display the deviation (%) between timestamp 2020 to 2021 for example within a powerbi-matrix ? Kind regards and thanks Rainer
