Tables, Numbers, Immutability And Power Query Performance

Following on from my last two posts on Power Query performance, I thought I would write about another trick that can make a big difference to your query execution times. It’s actually something that Ehren from the dev team mentioned in a forums thread that I blogged about here but it deserves to be better known.

Source : Chris Webb’s BI Blog
Read more…

Dynamics 365 BC October Release Features You Haven’t Heard Before

With the upcoming Dynamics 365 Business Central October release, all of you probably wondering what kind of new changes it will bring. We already know that we can prepare to say goodbye to C/Side and Windows Client, but what about other major changes?

In this article, Simplanova’s Project Manager Andrius will review new features of Dynamics 365 Business Central October release, that you possibly haven’t heard about before.

Source : Simplanova
Read more…

Adding More Aggregate Columns To The Output Of Table.Profile

A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data:

https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/

Since that post was written a new, optional second parameter has been added to the function called additionalAggregates which allows you to add your own custom columns containing aggregate values to the output of Table.Profile, so I thought I’d write a follow-up on how to use it.

Source : Chris Webb’s BI Blog
Read more…