Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, so I am working with some brand new data and i haven't used Bi is 3 to 4 months and forgot most of what i learned. So here it goes. I am trying to take those 2 columns and create a function or something to say this users.id will show the User first name and last name also( last names are removed due to privacy concerns.) any time I need to show the users name when it gets compared to any other section that calls the users.id.
So as you can see i would like to know if there is a way i can take image 1 and have it shown as a cross reference from first name to show as the name on image 2 instead of the id's. Any help will be greatly appreciated.
Solved! Go to Solution.
Initially, I would ask if there's any issue with using Power Query to merge the two tables based on User ID. If you can't do that, you can create a relationship between the two tables, and then use something like RELATED() to grab the name based on the same user ID.
Initially, I would ask if there's any issue with using Power Query to merge the two tables based on User ID. If you can't do that, you can create a relationship between the two tables, and then use something like RELATED() to grab the name based on the same user ID.
so when i did that it removed all the other data from one of the table and replaced it with only one set row from the other. Then it removed all the data that was in it currently. I forgot to mention i'm pulling the data from the web using json.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |