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
Icon for Resident Rockstar rankResident 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