The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Please check the above image where we have the correct way of calulating the growth. here for ex: AA category having data in 2019 from W7 but 2024 have W1 to W16 so we want the comparision to be
"Sum of all countries sellout for category (AA) W7 to W16 from Italy, DE W1 to W17, W3 to W16 for ES data, W1 to W16 from FR" for 2019
Same for 2024
"Sum of all countries sellout for category (AA) W7 to W16 from Italy, DE W1 to W17, W3 to W16 for ES data, W1 to W16 from FR"
Hi @AkkiJadeja ,
I can't help you very well. Maybe you could provide me with your pbix file?
When uploading pbix files, remove sensitive data and do not log into your account in Power BI Desktop.
Alternatively, you can create a virtual table to manually display your desired results and display them in screenshots or other forms.
All this is to better solve your problems.
I would be very grateful if you could get back to me as soon as possible.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |