Forum Discussion
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...
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.
Anonymous
is this what you want?
pls see the attachment below
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?
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.