Forum Discussion

Atinder's avatar
Atinder
Helper III
4 years ago

convert Inventory pcs to Displays

Hello,

 

I need help with Converting my inventory from pcs to Sales unit of measure  Which can be displays, PCS, mastercase.

 

How Can i link these 2 table or add new cloumn which can convert all my items from pcs to sales unit of measure.  So, I can see how many displays or master I have to sell.

 

 

 

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    It is not clear (to me) what the issue is. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where you are stuck?

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Atinder ,

     

    Is that you want some dax to get the inventory from table1 for table2. It just some thing like vlookup values in excel. If i am right, in Power BI you can try LOOKUPVALUE. If there are some relationships between table1 and table2, you can try to create column via RELATED('table1'[inventoty] ) in table2. Contribute to this, you need the primary column ( unique times in column of table1) avoiding get wrong result. Or some measures like this.

    Column =
CALCULATE(
    MAX( table1[Inventory] ),
    FILTER(
        table1,
        [No] = EARLIER( table2[Item_No] )
            && [Sales_Unit_of_Measure] = EARLIER( table2[Code] )
    )
)

     

    If i misunderstood you please share sample data and expect result.


    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.