Skip to content

Latest commit

 

History

History
66 lines (54 loc) · 827 Bytes

DAXSyntaxHighlight.md

File metadata and controls

66 lines (54 loc) · 827 Bytes

COALESCE

Coalesce is an interesting and powerful function. It takes two arguments (or measures), it returns the first argument, if the result of the first argument is blank, it returns the second argument

COALESCE = 

## expression
COALESCE( 
  // first argument
  [measure1], 
  // second argument
  [measures2] 
)
COALESCE = 

// expression
COALESCE( 
  // first argument
  [measure1], 
  // second argument
  [measures2] 
)
COALESCE = 

// expression
COALESCE( 
  // first argument
  [measure1], 
  // second argument
  [measures2] 
)
COALESCE = 

// expression
COALESCE( 
  // first argument
  [measure1], 
  // second argument
  [measures2] 
)
COALESCE = 

// expression
COALESCE( 
  // first argument
  [measure1], 
  // second argument
  [measures2] 
)