Create new table based on Distinct of two columns from other table

[caito103]

Hello,

Im trying to create a new table based on a table with differents columns, but i need to use just two of them:

This table have name of the seller and the store of each transaction realized, that is why each seller and store is repeated.

But the trick is that im trying to add in this new table just EACH SELLER with his STORE and not repeat it.

Also, i created a new table with each store and a code, if i try to make this new table and using each row to replace, for example, each STORE name for jsut the code, how i will be able to do it? I weas thinking use SWITCH DAX formula, but i can find how to extract the data first.

Thank you so much!

[v-yulgu-msft · Accepted solution]

Hi @caito103,

Suppose we have two basic tables: Table1 and Table2

     

Then, create a new calculated table using below formula. Also, in this new table, create a calculated column to show the code for each store.

New Table1 = SUMMARIZE(Table1,Table1[STORE],Table1[SELLER])

STORE CODE = LOOKUPVALUE(Table2[CODE],Table2[STORE],'New Table1'[STORE])

Best regards,
Yuliana Gu