Forum Discussion

Gaurav_84's avatar
Gaurav_84
Helper I
4 years ago

Filter column

Hi All,   Need you expert advice i want to create 2 columns within table using filter function. Below is how my data look. Column A include both home & design types & column B can be used for filt...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
4 years ago

Gaurav_84 , new columns 

Column B  = Switch( True() ,

search("Home",[ColumnA],,0) > 0 , "Home ",

search("Design",[ColumnA],,0) > 0 , "Design", Blank() )

 

Home = if([Column b] ="Home", "Home", blank())

 

Design= if([Column b] ="Design", "Home", blank())

  • Gaurav_84's avatar
    Gaurav_84
    Helper I
    4 years ago

    Hi Amit, Thanks for your response, i believe i have given the incorrect example. Right example should be like below one.

     

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Gaurav_84 , I think First switch has to change

      example

      Column B = Switch( True() ,

      [Column A] in {"Value1", "Value2", "ABC",

      //add others

      search("Design",[ColumnA],,0) > 0 , "Design", Blank() )

       

       

      If this does not help
      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

      • Gaurav_84's avatar
        Gaurav_84
        Helper I
        4 years ago

        Thanks Amit, I got bit confused can you please explain the query you have written with below data example.