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