Problem with DAX Formula reading a string in previous column

[dkcheney]

Scenario:
Creating a new column using a DAX formula. The formula is not creating the output I need.

My Experience Level:
2 Years PowerBI
3 Months DAX

Locations Table
Site#        Name                                             Type
1              Test Site CBOC                               ???? (New Column) Derived from formula below
2              Test Site Clinic
3              Test Site Resource

Formula
SWITCH(
TRUE(),
CONTAINSSTRING(VALocations[Name]="CBOC"),"CBOC",
"TBD"
)

My current output

Site#              Name                              Type
1                    Test Site CBOC               TBD
2                    Test Site Clinic                TBD
3                    Test Site Resource          TBD

[az38 · Accepted solution]

Hi @dkcheney 

pay attention to CONTAINSSTRING syntax: https://docs.microsoft.com/en-us/dax/containsstring-function-dax

use comma

CONTAINSSTRING(VALocations[Name], "CBOC")