Forum Discussion
FY Comparison
- 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
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