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

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

Hi,

Share the download link of the PBI file.