FY Comparison

[sdhn]

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 

[VahidDM · Accepted solution]

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/

[sdhn]

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.

[v-janeyg-msft · Accepted solution]

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

[VahidDM · Accepted solution]

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/

[sdhn]

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