• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.

  • 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

P

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
 
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
 
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.
 
You must log in or register to reply here.
Back
Top