Forum Discussion
sdhn
Responsive Resident
4 years agoFY Comparison
Hi All, I have three tables. FY1819 = values for Jul 2018 to Jun 2019. FY1920 = values for Jul 2019 to Jun 2020. FY2021 = values for Jul 2020 to Jun 2021. I need to calculate changes of ...
- 4 years ago
Hi sdhn
Check this:
Measure 1=
Var _Y1 = SUM(FY1920[Tickets Number])
Var _Y2 = SUM(FY1819[Tickets Number])
Var _Y1Y2 = _Y1-_Y2
return
_Y1Y2 - _Y2If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/ - 4 years ago
Hi, sdhn
You missed a parenthesis in formula.
Just add ')':
Measure1 = DIVIDE ( SUM ( FY1920[Tickets Number] ) - SUM ( FY1819[Tickets Number] ), SUM ( FY1819[ITickets Number] ) )Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
sdhn
Responsive Resident
4 years agoOn which table, Do I need to write formula/ measure?