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
