Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a problem in Power Query
I have a table with Record column but want record this column only with specific item in the Record column
I need to do this because when made only ExpandRecordColumn, a lot of rows that don't interesting me appears (i want only rows with specific item) and the performance of my query is affected because i filter this item after record column. I want to filter this item when recording to have a performance.
Do you know if it's possible ?
Thank you in advance
1. Add a new column by converting Record column to a table column.
2. Add another column to apply filtering with in the table before expand.
3. Remove actual record column and NewColumnName column.
4.Expand FilteredRecordColumn for required columns.
= Table.AddColumn( Source, "NewColumnName", each Record.ToTable([RecordColumn]))
= Table.AddColumn( Custom1, "FilteredRecordColumn", each Table.SelectRows([NewColumnName],each [id] ="9"))
= Table.RemoveColumns(Custom2,{"Record Column", "NewColumnName"})
Please Accept as a solution if it resolves your issue.
Have a nice day 🙂