Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Find text and int values in a column

I have the follwoing column containing Yes, No, Maybe and numbers from 0 to 100:   Column1 Yes No 3 Maybe 4 Yes 100   I am insterested in filtering the Yes, No and the numbers.   I tried...
Need Help
Show and Tell
  • ddpl's avatar
    ddpl
    4 years ago
    ==Creat calculated column through which you can filter.
    Filter Column= SWITCH(
    TRUE(),
    'Table'[Column1] = "No","No",
    'Table'[Column1] = "Yes","Yes",
    'Table'[Column1] = "May be","May be",
    "Number")
     
    Accept as solution if its worked