Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

May 2020 RS New DAX Function COALESCE doesn't work

I was excited to see when we upgraded to the May 2020 version that we can finally use coalesce as a dax function.  I loaded it right in tabular and deployed. Doesn't work. "Failed to resolve name COALESCE" even though SSAS tabular model correctly calculates it before deployment.  A friend said oh no it works inside of Power BI, ummm ok let me try that.  I typed in a new measure:  TESTMeasure = COALESCE (1,2) and immediately I see the red squiggly lines of terror. When I hover over them it says Cannot find name 'COALESCE' and 'COALESCE' is not a function.  So what happened to the May 2020 new features (Power BI Report Server May 2020 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI)?


Ed Watson

Super User I
Super User I

Hi @EdWatson ,

I can't say why it won't work in youre case. I test it and it works perfectly fine in May2020 Desktop for Power BI Report Server




Maybe deinstall and install it again 🙂








If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.