Forum Discussion

mkpado's avatar
mkpado
Helper I
8 years ago
Solved

DAX Horizontal Lookoup

I am looking to write a formula in DAX that will look with a records and deterime if a value exists in any of the columns associated with that record. For example lets say I have 5 records with 3 Che...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    There should be no use of a single |

     

    The double || is the operator for OR in logical tests.  There is a function called OR (..) that takes parameters.

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi mkpado

 

Please add the following calculated column to your table

 

Pass / Fail = 
    IF (
        'Table1'[Check 1] = "Error" ||  
        'Table1'[Check 2] = "Error" || 
        'Table1'[Check 2] = "Error" , 
        -- THEN --
        "Fail" , 
        -- ELSE --
        "Pass" 
        )
wwhittenton's avatar
wwhittenton
Helper II
8 years ago

Hi Phil_Seamark,

 

Is there a difference in using a single | vs two || to signal an OR statement in Dax?

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    There should be no use of a single |

     

    The double || is the operator for OR in logical tests.  There is a function called OR (..) that takes parameters.