Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive 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 ...
  • VahidDM's avatar
    VahidDM
    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's avatar
    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