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.
I am trying to create a new table that has a single row based on primary ID and column names from values in the data but I just can't get it to do it. There is no need for an calculations as value field is a string. Any help would be appreciated.
From this:
ID | Date | Value |
Id 1 | 1/01/2019 | X |
Id 1 | 5/01/2019 | Y |
Id 1 | 7/01/2019 | Y |
Id 2 | 2/01/2019 | X |
Id 1 | 10/01/2019 | Z |
to this:
ID | X | Y | Z |
Id1 | 1/01/2019 | 7/01/2019 | 10/01/2019 |
Id2 | 2/10/2019 |
Solved! Go to Solution.
Hello @BBurnett ,
You can achieve this with Pivot Function of Power Query, Go to Edit Query - Transform - Select value column - Pivot - then select Date from Drop Down and apply aggregation (if any) like Max date for the ID.
Thank You,
Washivale
Hey @BBurnett ,
just do that stuff in the ScreenGif. Be careful regarding the aggregation type. You have 2 dates for Y and need to decide what to do with it.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
Hey @BBurnett ,
just do that stuff in the ScreenGif. Be careful regarding the aggregation type. You have 2 dates for Y and need to decide what to do with it.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
Hello @BBurnett ,
You can achieve this with Pivot Function of Power Query, Go to Edit Query - Transform - Select value column - Pivot - then select Date from Drop Down and apply aggregation (if any) like Max date for the ID.
Thank You,
Washivale
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |