Measure for a new Column with if and contains

[Tober1996]

Hello, I like to create a new ColumnZ in my table with a measure. This measure should create the following value:

Check if ColumnX = empty

    Yes:  then check if ColumnY starts with "abc" ... If Yes: Write "1" to ColumnZ otherwise write "2" to ColumnZ

    No: Write text ColumnX to ColumnZ

I know, for professionals its an easy excel-if-function which is to be transferred, but I'm not a professional....

Thanks for help!

[Tober1996]

Thats perfect Jori!!!

Thanks a lot for the fastest help I ever got!

Tober

[jppv20]

@Tober1996 
If my reply helped, then please consider Accept it as the solution to help the other members find it more quickly.

[jppv20 · Accepted solution]

Hi @Tober1996 ,

This should work:

ColumnZ = IF('Table'[ColumnX]<>BLANK(),'Table'[ColumnX],IF(LEFT('Table'[ColumnY],3)="abc",1,2))

Jori