When to Use SUM() vs SUMX()

It has been 3 years since I first wrote an article about SUM() vs SUMX() and a year since I wrote the first version of this article. Over the years I have been teaching DAX, I have learnt new and improved ways to explain some of the more complex topics. This article is one of the most frequently read on my blog site and I wanted to update it to continue to improve the value people get from my site. Even if you have read this article before, why not take another look and refresh your knowledge.

Bron : Excelerator BI
Lees meer…

Calling The Power BI REST API From Microsoft Flow, Part 3: Finding All Data Sources Used In A Power BI Tenant

The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are there hundreds of Excel files being used as data sources for reports that you don’t know about? If so, where are they? Could they and should they be replaced by a database or something else more robust?

Bron : Chris Webb’s BI Blog
Lees meer…

How to Navigate and Optimize Power BI for More Effective Reporting

Microsoft Power BI is a reporting and analytics tool that can analyze data from a myriad of sources, including Microsoft Dynamics NAV, Excel, Google Analytics, social networks, APIs, Odata feeds, and more. Power BI allows for creation of interactive KPIs, charts, graphs, matrices, and other visuals to product unique and meaningful reports you can use to understand your business in real time.

Bron : ArcherPoint
Lees meer…

Application-wide system events (previously known as “Codeunit 1 events”)

You must have heard. Codeunit 1 is a goner! And if you have not heard it – you must have read about it. Because it has been on Microsoft Docks for a while, and also there was a blog that Microsoft spent on it.

Well, before I managed to find these description, I was working on my own overview ;-). So let me share it – I do believe that I look at it from another angle.

Bron : Waldo’s Blog
Lees meer…

Calling The Power BI REST API From Microsoft Flow, Part 2: Refreshing A Dataset When a Data Source Changes

For a while now I’ve had an idea stuck in my head: wouldn’t it be cool to build a Power BI solution where a user could enter data into an Excel workbook and then, as soon as they had done so, they could see their new data in a Power BI report? It would be really useful for planning/budgeting applications and what-if analysis.

Bron : Chris Webb’s BI Blog
Lees meer…