Dax IF Condition with a Concatenation

[rmeng]

I want a Dax with a IF Statement like this:

if [counts] = "Yes" then [date]&[mdm ID]&[User ID] else null

Can you Help me?

[harshnathani]

Hi @rmeng ,

Is this a Calculated Column or  a measure? 

For a Calculated Column

Calculated Column = if ('Table'[Count] = "Yes", 'Table'[date] & 'Table'[mdm ID] & 'Table'[User ID] , BLANK())

If [Count] is a measure.

Then create a measure

Measure = if ([Count] = "Yes", 'MAX(Table'[date]) & MAX('Table'[mdm ID]) & MAX('Table'[User ID]) , BLANK())

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[AntrikshSharma · Accepted solution]

You already provided the solution yourself:

CC = IF ( [counts] = "Yes", [date] & [mdm ID] & [User ID], "null" )