Forum Discussion

juhoneyighot's avatar
juhoneyighot
Icon for Helper III rankHelper III
2 years ago
Solved

Need help converting this Excel Formula to DAX language

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.

4 Replies

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    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's avatar
      juhoneyighot
      Icon for Helper III rankHelper III
      2 years ago

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

    • juhoneyighot's avatar
      juhoneyighot
      Icon for Helper III rankHelper III
      2 years ago

      Hello! Dangar332 

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

      Thanks

      • Dangar332's avatar
        Dangar332
        Icon for Resident Rockstar rankResident Rockstar
        2 years ago

        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.