Forum Discussion
Power query remove duplicates column based on slicer selection
Hi, My situation as follows. I have a table in query editor with column headers as follows. Spec1 Spec2 Spec3 default1 default2 default3.... By default the table was removed duplica...
Tables are only updated at refresh time, so a slicer cannot have this affect.
But with that being said, you can use a slicer value to create a virtual table and use that for a measure.
Can you upload some sample data with your expected output?