Forum Discussion

mkpado's avatar
mkpado
Icon for Helper I rankHelper 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.

wwhittenton's avatar
wwhittenton
Icon for Helper II rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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.