Forum Discussion

bajimmy1983's avatar
bajimmy1983
Advocate V
9 years ago
Solved

YOY DAX Measure

Hello again community. How are you?   Thank all that review my posts and have been helped.   Now I need to know why I have this scenario. Maybe I need to complement my Measure with some trick or ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    bajimmy1983

     

    Hi try the following as YOY% measure

     

    YOY% = Calculate (If(isblank([Prev Year Billing]),[SUM(MiddleOffice16_17[VALUE])]/[SUM(MiddleOffice16_17[VALUE])],([SUM(MiddleOffice16_17[VALUE])]-[Prev Year Billing])/[Prev Year Billing]) )

     

    And define this as type Percentage in the Modelling tab.

     

    If this solves your issue please accpet this as Solution and also give KUDOS.

     

    Cheers 

     

    CheenuSing

  • Anonymous's avatar
    Anonymous
    9 years ago

    bajimmy1983

     

    This is perfect. You can use the IFerror function to take care of exceptions.

     

    CheenuSing

  • Anonymous's avatar
    Anonymous
    9 years ago

    bajimmy1983

     

    If you have made the YOY%error as data type and have used the formula (Current Year - Previous Year) / (current Year) you will always the incremental percentageonly and not 100 + incremental percentage.

     

    This happens when your formula is [CurrentYear] / [PreviousYear]

     

    Hope this clarifies

     

    CheenuSing

Anonymous's avatar
Anonymous
Not applicable
6 years ago
YOY Billing Perc Growth:=DIVIDE([YOY Billing Growth];[Prev Year Billing];0)-1 is the answer