Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
Hi @Anonymous ,
You could duplicate the "organisation" and create relationships between new table and "sales" table. Then use RELATED() function to show the result.
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 =
Hope this helps!
Thanks.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |