Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Merged table (duplicates)

Hello Community:    The purpose of trying to merge tables in my case is because I need the Promotion Code column (yellow) to be available to me in another table.   It currently resides in the Order...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak TomMartens parry2k 

 

Thanks everyone.   Amit that video was helpful but the only issue is that the new query that is created is refernced back to the source file.      My issue is like this:    I have two tables.    A very simplistic view of them is below.   The "Promotion Code" field exists on my Orders table, but it does not exist on my Shipments table.    I need it to.   

 

Table 1  (Orders)                           Table 2  (Shipments)

Order ID                                         Order ID

Promotion Code                                 XXXX

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , If one order id has only one promo code. I would have that dimension and use. Or I can populate it back shipments. The way is to merge it with shipments in power query. There is a Dax way. But prefer a power query. 

 

If one order id has more than one promo code, how you want to use it?