topic Re: Dax IF Condition with a Concatenation in DAX Commands and Tips

Dax IF Condition with a Concatenation

rmeng — Wed, 01 Jul 2020 10:20:13 GMT

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?

AntrikshSharma — Wed, 01 Jul 2020 10:24:04 GMT

You already provided the solution yourself:

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

Anonymous — Wed, 01 Jul 2020 11:12:05 GMT

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!