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,
I have 3 measures
1. Companies (displays total companies)
2. Members (Displays total members)
2. Market (displays % of members/companies )
Now I need a new measure to display market growth
For example: To show the market growth % for 2017 and 2018 the formula should be
market % for 2018/market % for 2018 -1
Thanks
Hi @Anonymous,
For YOY % calculation, here are some links for your reference:
POWER BI – YEAR OVER YEAR (YOY) REPORTS USING SAMEPERIODLASTYEAR
Custom Year over Year calculation
For more advice, please provide dummy data and your expected output. How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |