Problem with DAX Formula reading a string in previous column

Question

Scenario:Creating a new column using a DAX formula. The formula is not creating the output I need.My Experience Level:2 Years PowerBI3 Months DAXLocations TableSite#&nbsp; &nbsp; &nbsp; &nbsp; Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Test Site CBOC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;???? (New Column) Derived from formula below2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Test Site Clinic3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Test Site ResourceFormulaSWITCH(TRUE(),CONTAINSSTRING(VALocations[Name]="CBOC"),"CBOC","TBD")My current outputSite#&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Type1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Test Site CBOC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TBD2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Test Site Clinic&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TBD3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Test Site Resource&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TBD

az38 · Accepted Answer

Hi&nbsp;dkcheney&nbsp;
pay attention to&nbsp;CONTAINSSTRING syntax:&nbsp;https://docs.microsoft.com/en-us/dax/containsstring-function-dax
use comma
CONTAINSSTRING(VALocations[Name], "CBOC")

Forum Discussion

Problem with DAX Formula reading a string in previous column

1 Reply

Related content

Measure formula problem

If formula

formula

DAX Formula Help

Problem with Formula