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

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