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.

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

remove the DIVIDE part and just keep the difference part.

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

Hi Ibendlin, sorry for the long delay. Thank you for the suggestion, it did work. Much apprecited!