Forum Discussion

amarinoRB's avatar
amarinoRB
Frequent Visitor
2 years ago
Solved

YoY % change not working properly..

I have input a formula for YoY percent change (picture 1 below) and it is working as intended with the revenue, but not for the other categories where I simply copied the formula and changed the meas...
Need Help
  • Anand24's avatar
    Anand24
    2 years ago

    amarinoRB ,
    Try this:

     

    YoY % Change (Revenue) =
    VAR LastYearRevenue = CALCULATE ( [Revenue YTD], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
    VAR Chg = DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
    RETURN
    IF (
    LastYearRevenue = BLANK () || Chg = -1,
    BLANK (),
    DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
    )

     

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
Anand24's avatar
Anand24
Icon for Super User rankSuper User
2 years ago

Hi amarinoRB ,
Try adding if statment to your RETURN statement:
IF(LastYearRevenue = BLANK(), BLANK(), DIVIDE([Revenue YTD] - LastYearRevenue , LastYearRevenue))

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn



amarinoRB's avatar
amarinoRB
Frequent Visitor
2 years ago

Hello Anand24, 
Thank you for the quick reply, but unfortunately this did not solve the issue. There currently is no data for Q4 for either of the further 2 columns, and the revenue is displaying how I would expect it to (-100%). Any other other suggestions?

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    2 years ago

    amarinoRB ,
    Try this:

     

    YoY % Change (Revenue) =
    VAR LastYearRevenue = CALCULATE ( [Revenue YTD], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
    VAR Chg = DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
    RETURN
    IF (
    LastYearRevenue = BLANK () || Chg = -1,
    BLANK (),
    DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
    )

     

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
    • amarinoRB's avatar
      amarinoRB
      Frequent Visitor
      2 years ago

      This worked! Thank you sir. I believe the the way I calculated YTD Revenue was incorrect as I am using the Date column from that table, and not the common date table I created. 

       

      'Revenue (Financial Statements)'[Date] vs 'Date'[Date]. Could you elaborate how that would affect the output

       

       

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Share the download link of the PBI file.