The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Experts,
I have a "Label" and "Value" columns in my dataflow. Most of the labels and their values are type strings.
However, there are few values which comes in as [List]. The [list] array has ONLY "one" string inside.
Is there a way I can expand the [list] array within the value column, which gets applied to each value which has [list] type?? so that the string inside array becomes the value?
Thanks
Solved! Go to Solution.
NewStep=Table.TransformColumns(PreviousStepName,{"fields.1.value",each if _ is list then _{0} else _})
NewStep=Table.TransformColumns(PreviousStepName,{"fields.1.value",each if _ is list then _{0} else _})