Forum Discussion

Responsive Resident

4 years ago

Solved

FY 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 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

sdhn
Responsive Resident
4 years ago
On which table, Do I need to write formula/ measure?
sdhn
Responsive Resident
4 years ago
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.
- VahidDM
  Super User
  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 - _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/
- v-janeyg-msft
  Community Support
  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