Forum Discussion
Anonymous
2 years agoNot applicable
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 ...
- 2 years ago
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
2 years agoAnonymous yes, please share your dashboard, and I'll help you troubleshoot the error.
Anonymous
2 years agoNot applicable
https://app.powerbi.com/groups/me/reports/b011633c-404f-4297-9b2f-a5eee933e07d/ReportSectioncb9ff538a6edec19730c?experience=power-bi
let me know if you can't access it.
- ahadkarimi2 years ago
Solution Specialist
Yes, I have no access.