Power Query Excel | M CODE - Merge Queries / Join Tables (Cover all Join Tables Functions)

[@signal03]

I like your Power Query's videos. How would you set up a slicer for numeric values columns? Suppose I have columns Prem1, prem2, prem3 and Prem = prem1+prem2+prem3. Is it possible to set up a slicer with enties Prem, prem1,prem2prem3?

[@bsmart2gether408]

Thank You, Eff Chek. I'm not sure if I am 100% understood your question. Slicer's value must be based on the row value. Not the column names. You will need to turn them into a column of text values. If this doesn't address your question. Please kindly provide a bit more information.

[@jhaanand81]

As always superb video 👍

[@bsmart2gether408]

Thank you, anand

[@alirezahossini463]

Good point

[@bsmart2gether408]

Thank you, Ali

[@larmondoflairallen4705]

What point?

[@jhaanand81]

Hi KT no video this week?

[@bsmart2gether408]

Hi Anand, there is a slight change in my personal schedule, but still, keep the fortnight video on my list. Almost done.

[@jhaanand81]

Thank you for your reply