Create Calculated column based on column value which are starting with "UC" character

[Anonymous]

Hello Team,
@danextian @v-henryk-mstf @Anonymous @V1 

I have a table where i need to have a new column based on "Alloc Entity Code" Column. In the New calculated column the values starting with "UC" character should only be displayed. Can anyone please help me with the DAX.

https://community.powerbi.com/t5/user/viewprofilepage/user-id/313

https://community.powerbi.com/t5/user/viewprofilepage/user-id/390395
https://community.powerbi.com/t5/user/viewprofilepage/user-id/396724

https://community.powerbi.com/t5/user/viewprofilepage/user-id/148838

https://community.powerbi.com/t5/user/viewprofilepage/user-id/245936

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

You could create a column as below:-

Column =
VAR _start_with =
    LEFT ( 'Table (3)'[alloc_entity_code], 2 )
RETURN
    IF ( _start_with = "UC", 'Table (3)'[alloc_entity_code] )

Output:-

BR,

Samarth