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 what needs to be corrected on my DAX calculation?

It would be perfect to get a new column YoY % on "FY19~FY22 Added" table.

 

Following is my measure:

PY PVO =
CALCULATE([Total PVO],DATEADD('FY19~FY22 Added'[YEAR],-1, YEAR))
 
Total PVO =
CALCULATE(SUM('FY19~FY22 Added'[PVO]),all('FY19~FY22 Added'[PVO]))
 
YoY = [Total PVO]/[PY PVO]-1 
*question: is it correct to express % ?
 
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.

7 Replies

  • 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