Forum Discussion
Create a mapping table and automatically update Dashboards
Hey Anonymous ,
that's usually a data preparation task.
Create a mapping table in your data source or if you want also in Excel or directly in Power BI. It should have two columns, one for the correct client name or the name you want to see in the report and one column for the synonyms. Then for each synonym add a new line to map it to the correct name.
In Power Query you then merge this table (is like a join in SQL) to the real table and replace all the duplicate entries with the correct one.
Then you can analyze all the data together.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Most Valuable ProfessionalHey Anonymous ,
that's usually a data preparation task.
Create a mapping table in your data source or if you want also in Excel or directly in Power BI. It should have two columns, one for the correct client name or the name you want to see in the report and one column for the synonyms. Then for each synonym add a new line to map it to the correct name.
In Power Query you then merge this table (is like a join in SQL) to the real table and replace all the duplicate entries with the correct one.
Then you can analyze all the data together.