coalesce
2 TopicsMay 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 WatsonSolved4.9KViews0likes8Comments