Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

YoY % Expression

Hi Power BI Community!   I am a beginner starting Power bi tool recently as a Purchaser. I would like to express YoY of Purchase volume(PVO) over time in dashboard.  Would you be able to identify...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    since your request is YOY, so I only get the year value, if your request is MOM, then we need to add Y/M column. if you don't use if function, the first year's yoy is infinity. That doesnot make sense. usually we set it as blank.

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

do you have a calendar table?

could you pls provide the sample data and expected output?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Yes, I have a calendar table which consists of 4 period

     

    and expected output is YoY % per description. I would like to share sample data with you but, it cannot be loaded. Do you know how to upload it?

     

     

     

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      5 years ago

      Anonymous 

      it's a calendar table. caleandar table is based on day ,not year.

      maybe you can share your pbix file via onedrive or others