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.
First, my apologies because this must be easy and already answered, but I can't figure it out, nor find a post with a solution.
I think two images will show what I am trying to do much better than what I could explain, so here they are:
I need to do it with Power Query and not DAX because the actual tables are a little bit trickier...
I appreciate your help 🙂
Solved! Go to Solution.
Try breaking those into two queries, and then merging on the ID. You can duplicate and hack away the columns accordingly.
Hi,
@ImkeFshould be able to help with the appropriate M code for solving this. @Anonymous, in the second image, you have not shown the KeyB column. Please show us the entries that should appear there.
Try breaking those into two queries, and then merging on the ID. You can duplicate and hack away the columns accordingly.
I knew I was missing something. Thanks for taking the time to answer my silly question.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |