The April 2019 update to Power BI has many good features, as this blog explains
Part three of a nine-part series of blogs

The April 2019 update to Power BI introduces a new concept: the ability to make the value of a property dynamic. Other welcome new changes include M Intellisense, data profiling in query editor and cross-report drill-down.

  1. The April 2019 Update to Power BI Desktop
  2. Conditional titles for visuals and conditional URLs
  3. Intellisense in the M Query Editor Language (this blog)
  4. Data profiling in Query Editor
  5. Cross-report drill-through
  6. Fuzzy merging
  7. Power BI Dataflows
  8. Other changes in the April 2019 update
  9. Power BI features waiting in preview, as of April 2019

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 18 April 2019

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.

Intellisense in the M Query Editor Language

OMG!

So suppose you have a table of course dates which you're playing around with in Query Editor:

Course dates

We want to find the end date for each course, by adding the number of days onto the start date.

You add a custom column:

Adding custom column

The tool to add a custom column in Query Editor.

 

You then have absolutely no idea what to do next!

Custom column editor

The formula editor for M.

Except ... now you do.  You want to add days, so type in Add:

Autocompletion

After a tiny pause, this appears! The function you want is probably Date.AddDays.

 

When you choose the function, you see its arguments:

Argument signature

The arguments for this function.

It's now almost trivial to build the formula:

The final formula

I realise that I actually need to subtract one from the result, since a one-day course actually begins and ends on the same day ...

 

The most moving change in this month's update! 

This blog has 0 threads Add post