Dynamic Percentage Change

[akshay-adglobal360]

I need to get the percentage change of data in (10%) percentage format dynamically. It should change according to data. How to do that ? Scenario- net retail for august 2023(MTD) IS 10% less than august 2022(MTD)

[Vegar]

To calculate the change you need to know the net retail for August 23 and August 22.

Assuming you have a date field named [Date] you can get those values using set analysis. 

MTD: =sum({<Date={">=$(=MonthStart(max(Date)))<=$(=max(Date))"}>}[Net retail])

MTD_PY: =sum({<Date={">=$(=MonthStart(max(Date),-12))<=$(=addmonths(max(Date),-12))"}>}[Net retail]) 

To calculate the change use

1 - ((MTD- MTD_PY)/MTD_PY)