Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Excluding a value from condition

I am trying to filter out records where the column Device_Name contains = "ESX" or "Appliance". I have this query:   IF(NOT(CONTAINS(TableName,Device_Name,"ESX||"Appliance")))   The problem is th...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, i advise using LEFT function.

    I create a simple sample to test:

    Then create a column to extract specified string like 'esx' or 'Appliance':

     

    Column = IF(LEFT('Table'[Device_Name],3)="esx"||LEFT('Table'[Device_Name],9)="Appliance",1,0)

     

    Apply a filter about this column to the visual, the result shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

According to your description, i advise using LEFT function.

I create a simple sample to test:

Then create a column to extract specified string like 'esx' or 'Appliance':

 

Column = IF(LEFT('Table'[Device_Name],3)="esx"||LEFT('Table'[Device_Name],9)="Appliance",1,0)

 

Apply a filter about this column to the visual, the result shows:

Hope this helps.

 

Best Regards,

Giotto Zhi