Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 there are values under Device_Name such as Labesx which I don't want filtered out. I just want to filter out device names that just contain the word ESX separately such as (esx-111, esx-222, esxI, rather than being a part of a string such as labesx.
How do I accomplish this?
Solved! Go to Solution.
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
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
Try something like this:
Table 2 =
FILTER(
'Table',
SEARCH("ESX",[Name],1,-1) <> 1 &&
SEARCH("Appliance",[Name],1,-1) <> 1
)
PBIX attached.
Make it an AND statement:
IF(NOT(CONTAINS(TableName,Device_Name,"ESX")) && NOT(CONTAINS(TableName,Device_Name,"Appliance")), <value for true>, <value for false>)
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |