Forum Discussion
Percent Change Help
Hi- looking for help on how to calculate a simple year over year percent change. The first table shows the totals for each period in three fiscal years. Table two uses a measure to try and calculate ...
My question on that example is I'm clear on why that additional table is needed.
I did not have any problem with your Calculation, if you want I can share my PBIX ...
Total Sales LY =
VAR LY = SELECTEDVALUE(Orders[Year of Order Date],1)-1
VAR PY_AMT=
CALCULATE(sum(Orders[Profit]),
Orders[Year of Order Date]=LY
)
VAR RESULT=(SUM(Orders[Profit])-PY_AMT)/PY_AMT
RETURN RESULT
Regards,
Ritesh