WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 529 reviews for our classroom and online training
The March 2020 update to Power BI desktop is a full one, as this blog shows!
Part eight of a eleven-part series of blogs

New goodies in this month's update include the roll-out (sort of) of the new ribbon, new actions for buttons, multi-column sorting and a second axis for line charts.

  1. The March 2020 Power BI Desktop Update
  2. The new ribbon is live (sort of)
  3. Page navigation buttons
  4. Drill-through navigation buttons
  5. Multi-column sorting
  6. Searching in the filter pane
  7. Line charts can now have a dual axis
  8. The new DAX COALESCE function (this blog)
  9. Changes to ArcGIS
  10. Query Diagnostics
  11. Generating embed codes is now turned off by default

For a cumulative list of all of the updates to Power BI Desktop in the last few years see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 14 March 2020

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

The new DAX COALESCE function

I'm going to struggle to enthuse about this, because DAX now has a function to mirror the SQL COALESCE function - and I never use that!

DAX function SQL equivalent
ISBLANK ISNULL
COALESCE COALESCE

Here's the syntax of this function:

COALESCE syntax

Keep trying different expressions until you find one which doesn't return blank.

I would normally include an example here, but I just can't think when you could possibly need this in a measure or calculated column!

This blog has 0 threads Add post