Need help converting this Excel Formula to DAX language

[juhoneyighot]

I need help for this Excel Formula to be converted to DAX

1. =IF(ColumnA<>"","Y","N")

2. =IF(OR(ColumnD="00Test 00TestLast",ColumnD="00test newcon"),"Y","N")

Thank you.

[Dangar332]

hi, @juhoneyighot 

try below code 

measure1 =
   if('yourtablename'[columnname that you compare(columnA)]<>"","y","n")

measure 2 =
   if('yourtablename'[columnname where you compare(columnD)]="00Test 00TestLast" ||
    'yourtablename'[columnname where you compare(columnD)]="00test newcon","y","n")

[juhoneyighot · Accepted solution]

Hello! @Dangar332 

the formula works in a "new column' not in a 'measure'.
It is solved already.

Thanks

[Dangar332]

Hi, @juhoneyighot 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. and don't forget to give kudos.

[juhoneyighot]

Hello! This is the error when I'm trying to enter the formula