Forum Discussion

Mk60's avatar
Mk60
Icon for Resolver I rankResolver I
2 years ago
Solved

Period over Period variance

Looking for a DAX calculation to calculate change in dollars, (variance) for Metrics 1-5 in column A, from quarter to quarter to get values in columns E and F for each metric in column A and Total as...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    remove the DIVIDE part and just keep the difference part.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Mk60 ,
Thanks for lbendlin  and lbendlin  response. Here are my additional dax expressions and examples
Sample data

Create measures

Q2-Q3 = SELECTEDVALUE('Table'[23-Sep])-SELECTEDVALUE('Table'[23-Jun])
Q3-Q4 = SELECTEDVALUE('Table'[23-Dec])-SELECTEDVALUE('Table'[23-Sep])

Final output

 

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly