Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hozefamk
Frequent Visitor

Searching for first two letters in DAX

Problem statement:
If First 2 letter of ICODE = 51 then Computers else  If First 2 letter of ICODE = 11 then Raw MaterialsCapture.PNG
1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

Hi @hozefamk

 

You could try something along these lines

 

Column = 
    SWITCH(
           TRUE() ,
           MID('Table'[ICODE],1,2) = "51" , 'Table'[Computers] ,
           MID('Table'[ICODE],1,2) = "11" , 'Table'[Raw Materials] ,
           BLANK()
          )

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Phil_Seamark
Employee
Employee

Hi @hozefamk

 

You could try something along these lines

 

Column = 
    SWITCH(
           TRUE() ,
           MID('Table'[ICODE],1,2) = "51" , 'Table'[Computers] ,
           MID('Table'[ICODE],1,2) = "11" , 'Table'[Raw Materials] ,
           BLANK()
          )

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.