Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!