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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

You cannot get 2 total columns (E and F) in a table/matrix visual.  You can show one 1 variance column.