topic Re: FY Comparison in DAX Commands and Tips

FY Comparison

sdhn — Thu, 20 Jan 2022 23:52:13 GMT

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 total counts of "Tickets Number" in the Fiscal Year. I put total counts on boxes.

now need to calculate changes. Formual to calculate changes is "Previous FY - Current FY / Current FY".

Help will be appreciated.

Thanks

Re: FY Comparison

sdhn — Fri, 21 Jan 2022 00:10:32 GMT

On which table, Do I need to write formula/ measure?

Re: FY Comparison

sdhn — Fri, 21 Jan 2022 00:52:27 GMT

I wrote measure on FY1819 but getting error.

Measure 1= DIVIDE(SUM(FY1920[Tickets Number]) - SUM(FY1819[Tickets Number],SUM(FY1819[ITickets Number]))

Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.

Re: FY Comparison

VahidDM — Fri, 21 Jan 2022 05:29:05 GMT

Hi sdhn

Check this:

Measure 1=
Var _Y1 = SUM(FY1920[Tickets Number])
Var _Y2 = SUM(FY1819[Tickets Number])
Var _Y1Y2 = _Y1-_Y2
return
_Y1Y2 - _Y2

If 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/

Re: FY Comparison

v-janeyg-msft — Tue, 25 Jan 2022 06:53:37 GMT

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