Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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

Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

     

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    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