Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.