Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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 |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |