I'd love to know how anyone was able to submit a solution since the email address was covered by a plug for a Power BI video! I had a solution which used a Data Validation List for the header of the Filter Table which then used the appropriate data validation list for the rows of that table. When the header changed, existing choices became unreadable using Conditional Formatting which set the same color for the font and background so one would know it had to be fixed. Would have been nice to be able to have provided that. The one good solution provided was pretty straight forward, the other results in empty row(s). Not so interesting.
good explanation but I would leave out the custom column and just make use of Record.Field Function to dynamically select the Column-Value for the Filtercriteria let source= DataTable, FiltererdTable = Table.SelectRows(source,each List.Contains(List.First(Table.ToColumns(FilterTable)), Record.Field(_,List.First(Table.ColumnNames(FilterTable))),Comparer.OrdinalIgnoreCase)) in FiltererdTable
Great video, masterful explanation. Greetings and thanks
Thank you 🙏
really very informative and helpful in routine work. Thank you.
Thank you, happy that you liked it
I'd love to know how anyone was able to submit a solution since the email address was covered by a plug for a Power BI video! I had a solution which used a Data Validation List for the header of the Filter Table which then used the appropriate data validation list for the rows of that table. When the header changed, existing choices became unreadable using Conditional Formatting which set the same color for the font and background so one would know it had to be fixed. Would have been nice to be able to have provided that. The one good solution provided was pretty straight forward, the other results in empty row(s). Not so interesting.
Sorry for that i didn’t notice, but the email was also below in the description box
good explanation but I would leave out the custom column and just make use of Record.Field Function to dynamically select the Column-Value for the Filtercriteria
let
source= DataTable,
FiltererdTable = Table.SelectRows(source,each List.Contains(List.First(Table.ToColumns(FilterTable)), Record.Field(_,List.First(Table.ColumnNames(FilterTable))),Comparer.OrdinalIgnoreCase))
in
FiltererdTable
First of all, sorry for the late reply, second, thank you so much for sharing your brillant solution, much appreciated