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 all,
I'm in charge of procurement at my company. We have over 500 products coming from 12 International Suppliers and only 1 person in our Supply Chain Department which is me. 🙂
I'm trying to see the top 100 SKUs sold per a particular month divided on sepearte tables within one page in Power BI. I would like each table to be differentiated based on the info provided below:
Key:
Monthly YOY QTY Sold % Change = X
Monthly MoM QTY Sold % Change = Y
Profit MoM % Change = Z
Profit YoY % Change = W
Tables:
Table 1 -> X Increased , Y Increased, Z Increased, W Increased
Table 2 -> X Increased , Y Increased, Z Increased, W Stayed the Same
Table 3 -> X Increased , Y Increased, Z Increased, W Decreased
Table 4 -> X Increased , Y Increased, Z Stayed the Same , W Increased
Table 5 -> X Increased , Y Increased, Z Stayed the Same , W Stayed the Same
Table 6 -> X Increased , Y Increased, Z Stayed the Same , W Decreased
There will be a total of 27 Table to begin with. I will then merge these into 4 based on reviews with our management team and any advice from you guys.
Salesfroce is our main database which is currently connected to Power BI. My database includes the following fields: CreatedDate, QTY Sold, Product SKU, Profit.
It would be ideal to see the follwoing info on each table.
Prdouct SKU --- X Value ---- Y Value ---- Z Value ---- W Value
Any help is truly apperaitied.
Roham
HI @rohampourmehr,
Can you please provide more detail content to help us clarify your scenario?(your measure formulas, screenshots, table structures and relationship, expected result)
Reards,
Xiaoxin Sheng
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |