ISBlank then value, if not blank then value

[Alaska1]

I have one data field where I want to be able to assign a value to ISBlank and a value if not blank.

Example:

Blank = Requests

Not Blank = Communication.

What

[NaveenGandhi · Accepted solution]

Hi @Alaska1 

A simple calculated column with below DAX would work.

if(ISBLANK('Table'[FirstName]),'Table'[LastName],'Table'[FirstName])

Let me know if you have any questions.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!