Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community - I have an orders table that includes a column for salespeople. I also have a dimension table with employee names.
In my orders table, the Salesperson column list the salespeople as DavidB or MaryS, etc. I do not want this, but rather the full name. I have about 100 names to change.
I would like to use my employee dim column on my dim table as the reference for the full name.
Is there an expedient way to do this in Power Query?
If you really want to do this in Power Query I'd read through this example here:
You'd need to add a column to your employee table in the same "FirstnameInitial" format to perform the lookup.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |