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)?
Solved! Go to Solution.
Yeah, it is frustrating.
I only found out because my colleague pointed me to https://dax.guide/coalesce/ and on the right side there is a menu called "Compatability" and at the end of it there is an option to "Show verified builds".
When you click that you will notice there is no build version mentioned at SSAS Tabular.
And that is frustrating as well because the default picture makes it appear that it does work which is misleading. I don't think I've ever clicked the verified builds before (but I will now).
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!
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!