Forum Discussion

rohampourmehr's avatar
rohampourmehr
Frequent Visitor
8 years ago

Decision Tree Used as a Filter

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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