Forum Discussion

mkrmenci's avatar
mkrmenci
New Member
8 years ago
Solved

Using Search function within Switch

Hi Folks,   I'm trying to create a new query that will search through a column looking for cells that contain specific text. I'm using the SWITCH function and so far its working great.  Example.  ...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi mkrmenci，

     

    I have made a test with your dax expression in Power BI Desktop (Version: 2.56.5023.942 64-bit (March 2018)), everything works well. It seems that your formula should be right,

     

     

    Please check if you have update the latest Power BI Desktop.

     

    By the way, what is your data source and how do you connect it?

     

    In addition, you could have a reference of my test pbix file.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi mkrmenci，

 

I have made a test with your dax expression in Power BI Desktop (Version: 2.56.5023.942 64-bit (March 2018)), everything works well. It seems that your formula should be right,

 

 

Please check if you have update the latest Power BI Desktop.

 

By the way, what is your data source and how do you connect it?

 

In addition, you could have a reference of my test pbix file.

 

Best Regards,

Cherry

monojchakrab's avatar
monojchakrab
Resolver III
4 years ago

Hey v-piga-msft ,

 

This solution seems to be working for me but with >1, instead of =1 : not sure why.

 

I also am not clear what is True() and Blank() doing in the code - those are not standard parameters for the SWITCH function, right?