November 2018 – Page 2

Use IsInScope to get the right hierarchy level in DAX

In the November release of Power BI desktop we introduced a new DAX expression that is really great. Working with hierarchies in DAX have always been a bit of a pain, especially in scenario’s where you need to change your calculation based upon the level that…

23 November 2018

Data & Analysis

Create a Planning View of Your Outlook Diary in Power BI

The first thing I did was to connect Power BI Desktop to my Exchange server. There are 2 choices and it depends on your setup which you use. I have my own domain and O365 configured to use Microsoft Exchange, so I connected to the second…

22 November 2018

Data & Analysis

How Do I: Create a PowerPoint presentation of a Power BI report?

A question I get asked sometimes, during my Power BI trainings is, can I use PowerPoint to display my Power BI reports and dashboards? Yes of course, I usually answer, and then I explain, that in your Power BI workspace, when you select your report, in…

21 November 2018

Data & Analysis

Using Function.ScalarVector() To Optimise Calls To M Functions

One of the most common issues faced when calling web services in M is that the the easiest way of doing so – creating a function that calls the web service, then calling the function once per row in a table using the Invoke Custom Function…

20 November 2018

Data & Analysis

Nested Display Folders In Power BI

The ability to add columns and measures to display folders in the new Modelling view is one of my favourite features of the November 2018 release of Power BI Desktop: it makes complex models a lot more user-friendly. Being an old-school SSAS developer, I immediately wondered…

19 November 2018

Dynamics NAV & BC Tips & tricks

Stock Procurement – Maximising the Benefits of the Planning Worksheet

The Dynamics 365 Business Central Planning Worksheet is a powerful tool that, with fine-tuning, will provide great benefit to your procurement team. It reviews the supply and demand, both actual (from existing documents) and expected (from a production forecast) to suggest replenishment orders. Bron : Fenwick…

16 November 2018

Dynamics NAV & BC Tips & tricks

Small tip – huge advantage – and one I forgot about until AJ reminded me of it yesterday: the “system information” page in Microsoft Dynamics 365 Business Centeral. An – as far as I know – undocumented feature, but one worth mentioning! Bron : Waldo's Blog…

15 November 2018