Forum Discussion
Dynamic YoY percentage %
Hello all, I've searched mulitple posts on this forum to try to solve this problem and I have had no luck so far. I want to be able to calculate a percentage change of different fiscal years ...
Hey Anonymous, make the following changes for the 2nd year:
RiderSelected2ndYear = VAR SelectedYearNumber = VALUE(RIGHT(SELECTEDVALUE('xFY Calender'[FY]), 2)) VAR PreviousYearNumber = SelectedYearNumber - 1 VAR PreviousFY = "FY" & FORMAT(PreviousYearNumber, "00") RETURN CALCULATE( [TotalRiders], FILTER( ALL('xFY Calender'[FY]), 'xFY Calender'[FY] = PreviousFY ) )if you would like to display a dash (-) instead of 'Blank' in the card, use the code below:
YoY % = IF( ISBLANK([RiderSelectedYear]) || ISBLANK([RiderSelected2ndYear]), "-", DIVIDE([RiderSelectedYear], [RiderSelected2ndYear], 0) )Please let me know what happend and if there are any issues.
ahadkarimi
Solution Specialist
Solution SpecialistHey Anonymous, try this code, and if you encounter any issues, let me know.
YoY % =
IF(
ISBLANK([RiderSelectedYear]) || ISBLANK([RiderSelected2ndYear]),
BLANK(),
DIVIDE([RiderSelectedYear], [RiderSelected2ndYear], 0)
)Hello ahadkarimi,
I'm still getting the same error. Let me know if you need me to share my dashboard.Thank you,
- ahadkarimi
you can share it in microsoft onedrive or google drive and put it here or send it by mail to [email protected]
let me know if this works, I saved it onto a google drive.
https://drive.google.com/file/d/1il0EgIIT4H_8D7t6bzuim_vALyTxRpKH/view?usp=sharing
Thanks!