ISNULL query in Power BI

[praveensc2021]

I need to handle ISNULL using DAX. Tried lots of ways did not succeed.
Posting SQL query below

CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName +' ' + LastName END AS FullName

how to achive this using DAX

Thanks

 

[Chihiro]

Use ISBLANK() or check for LEN() = 0.

 

[praveensc2021]

i have tried this

IF(ISBLANK('Person Person'[MiddleName]), 'Person Person'[FirstName] + 'Person Person'[LastName],'Person Person'[FirstName] + 'Person Person'[MiddleName] + 'Person Person'[LastName])

Did not work

 

[Chihiro]

How and where it's used matters in DAX. Is it a measure? Calculated column?

I'd recommend uploading sample data model that demonstrates your issue. As well as sample/explanation of what the end result should look like.