cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PhoenixBird66 Regular Visitor
Regular Visitor

DAX New Column - if values in one column are blank use the values from another column on a different

I'm trying to create a new column (Description3) using DAX which says if the value in the "Description1" column is blank or null, then use the value of another column [Description2] from a different table.

 

If both are blank, then leave it blank.

 

Capture.JPG

 

Any ideas how best to do this?

 

Thanks

1 REPLY 1
Super User
Super User

Re: DAX New Column - if values in one column are blank use the values from another column on a diffe

@PhoenixBird66 If you want to retrieve a value from a column in another table, then try using "LOOKUPVALUE" function in your new calculated column.



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,994)