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

 



 



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

Hi Albert,

Thanks so much for your sample. I was hoping your solution was exactly what I need, but Unfortunately, I just can't make it work for me, and wonder if you could help me how to actually pick the single date in this DAX formula? I think what you have in your example as "[23-Sep]" is a Date column value in my table named "Query1". If I follow your calc I just cannot select unique date "23-Sep" since DAX is suggesting .[Month], or .[Quarter] or day. I tried to manually type it but that's not working. Maybe if I attach this picture of my column it might help you see the issue? As you can see my Date is coming from my calulated column named "Posting DATE SHORT", which I created from the existing date filed "Posting Date" in my Query1 table. Your time and willingness to help is much appreciated!