Forum Discussion
YoY Calculation
I have a snapshot table that gets a policy in force count(pif) at the end of every month. I need to know how to calculate Year over year change. So in the data below for April 2022, I want to com...
Hi
Try this
sales Actual=calculate(sum(sales[sales])
sales year PY=calculate([sales Actual],SAMEPERIODLASTYEAR('Date'[Date]))
thank you I will try this and let you know