Hi Guys,
i want to give possibility to user to filter one column table from form and checkboxes.
User will choose specific options and based on that table will be filtered, or created, or...
I would like to join this table with my source table based on choosen values from user.
So restrict Source table with choosen values by user.
How can i do this using power query?
Should i create separate table and use it as inner join?
Or maybe there is possibility to get filtered table values as source into power query?
I know that i can filter in PQ but i have to somehow pass to PQ what i want to filter and use.
Please help,
Best,
Jacek
Assuming you can't simply apply the filter to the PQ output, here's one method per Chris Webb: https://blog.crossjoin.co.uk/2015/03/09/using-excel-slicers-to-pass-parameters-to-power-query-queries/
Thank you very much, working like a charm!
Best,
Jacek