YoY % Expression

[Anonymous]

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

[ryan_mayu]

@Anonymous 

do you have a calendar table?

could you pls provide the sample data and expected output?

[Anonymous]

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]

@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

[Anonymous]

Yes, I tried to put calandar with full date but, raw data doesn't represent a specific date. So I just let only year appear on it. Can you access to this link?

https://drive.google.com/file/d/1rMaPKctmCxFkirgYSSpQreaXr5z-cvOn/view?usp=sharing

[ryan_mayu]

@Anonymous 

is this what you want?

pls see the attachment below

[Anonymous]

There we go! Thank  you so much, Ryan.

I am following my mistakes to see your measure. 

You made a calandar table and then set "year" for expression

And blank needs to be replace with a recognized cell. right? 

[ryan_mayu · Accepted solution]

@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.