Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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.
Proud to be a Super User!
@Anonymous
do you have a calendar table?
could you pls provide the sample data and expected output?
Proud to be a Super User!
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?
@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
Proud to be a Super User!
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
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |