MERGE TABLES BY USING DAX(without power Query editor)

[Anonymous]

I have two tables (1.organisation having columns  -organisation id(number),organisation code(string),region 2. sales having columns - organisation id (number),product organisation id(number)).

i want a table visulas in which all the product organisation id has to be shown in codes(string-which means it should be mapped to organisation code)instead number format.how can i merge those two to get the result by using DAX

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could duplicate the "organisation" and create relationships between new table and "sales" table. Then use RELATED() function to show the result.

[Anonymous]

Hi @Anonymous ,

I have created a new table from Sales table and then looked up 'organization code' from Organization table.

DAX:

To create new table: New Table = (Sales)

To look up organization code = 

Organization Code = LOOKUPVALUE(Organization[Organization Code],Organization[Organization id],'New Table'[Organization id])

Hope this helps!

Thanks.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

there  is a tabular visual in the provided picture having organisation id,organsation code and product organisation id..in the product orgnaistion id columns i want codes like (IND,AUS) instead of numbers (1,2,3,..)..for that im asking how to merge/combine tables to get it in DAX