• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ISNULL query in Power BI

praveensc2021

New Member
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
 

praveensc2021

New Member
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

Excel Ninja
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.
 
Top