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 everyone,
Following is my assumption, I have 4 columns in my raw data - Column Name, Channel, Placement and Content.
I want to use data in "Column Name" as column names and use data in that column cell accordingly to generate "Custom Column".
Is there a way of doing so in Power Query?
I understand a column is expressed in square brackets, but what expression should I use to achieve the above?
Thank you so much for your time and help.
Solved! Go to Solution.
Try this custom column from Query Editor
=Record.Field(_,[ColumnName])
Try this custom column from Query Editor
=Record.Field(_,[ColumnName])
Didn't know this expression! Work like charm! Thank you!
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.