Forum Discussion
How can i use the if funtion for the changes ?
Hey everybody, i want to calculate the %change and %point change from the Current year and period to the last year and period. How can i do this by using the IF Funtion or another function ? ...
Try:
=LET(lastYr, XLOOKUP( ([@YEAR]-1)&[@[MTD/YTD]]&[@Period], [@YEAR]&[@[MTD/YTD]]&[@Period], [Sales(mEU)], 1), ([@[Sales(mEU)]]-lastYr)/lastYr)