=DIVIDE([Units Sold]-[Units Sold Last Year], [Units Sold Last Year]

[jersey]

Hi Guys,

I had used the Dax formula below to get the variance year over year. However, I was looking for 364 days ago and not one year. How can I change the formula?

=DIVIDE([Units Sold]-[Units Sold Last Year], [Units Sold Last Year]

Thank you so much,
Cindy

 

[scottsen]

Can you show us your [Units Sold Last Year] measure?