How to add filter to "Switch"?

[bcbuckley13]

Hello and thanks in advance.

I'm a beginner user and need to add a filter to this slicer, specifically for this "Turkey Time" contest.

There's a game being played, Know our Product, that I need to filter out that was played between Nov 7-18.

This same game was played on earlier dates, so I don't want to remove it from other contests.

Can I add that here?

[v-rongtiep-msft · Accepted solution]

Hi @bcbuckley13 ,

If you want to include all of the other games within those dates, EXCEPT for the "Know our Product". 

Please have a try.

contest=switch(true(),table[played on]>=date(2022,11,7)&&table[played on]<=date(2022,11,18)&&table[game name]<>"Know Our Product","&_Turkey Time",blank()

Add the &&table[game name]<>"Know Our Product" after the <=date(2022,11,18).

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bcbuckley13]

I actually want to do the opposite.  I want to include all of the other games within those dates, EXCEPT for the "Know our Product".

[v-rongtiep-msft · Accepted solution]

Hi @bcbuckley13 ,

If you want to include all of the other games within those dates, EXCEPT for the "Know our Product". 

Please have a try.

contest=switch(true(),table[played on]>=date(2022,11,7)&&table[played on]<=date(2022,11,18)&&table[game name]<>"Know Our Product","&_Turkey Time",blank()

Add the &&table[game name]<>"Know Our Product" after the <=date(2022,11,18).

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bcbuckley13]

I'm getting this error. I'll try and upload a pbix file.

[v-rongtiep-msft · Accepted solution]

Hi @bcbuckley13 ,

Remove the comma.Pay attention to these small details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bcbuckley13]

Thank you so much!!! This worked. So much to learn about PBI still.

Question....can I use Switch twice on the same table? I'm trying to duplicate this one, but then not include the game names.

[v-rongtiep-msft]

Hi @bcbuckley13 ,

If you only want to add the Know our Product between Nov 7-18., you can add it.

Please have a try.

contest=switch(true(),table[played on]>=date(2022,11,7)&&table[played on]<=date(2022,11,18)&&table[game name]="Know Our Product","&_Turkey Time",blank()

Add the &&table[game name]="Know Our Product" after the <=date(2022,11,18).

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.