Author: Marnix Jansen

Home Articles posted by Marnix Jansen
Roles

The four Power BI roles

#Powerbi users can actually be divided into four different roles. Read all about it in this article. Introduction When talking about "the Power BI user", I find it useful to distinguish between four different kind of users. They all need a different approach when it comes to training, guidance, software and licenses. For the PL-300 (Power...
StartPage

IBCS ®️ P&L Waterfall chart using Charticulator in Power BI

In this video I demo how to create a waterfall chart for a Profit and Loss statement based on the IBCS®️ standard. I'll demo this in the standard Power BI visuals as well as in Charticulator. Using this standard it is far easier for report users to get insight into the financials of an organization.
StartImage

Add a row for every day in between two dates

When you have a table that contains events with a start and an end dat, you sometimes need to expand it out so that you have a row for every day in between the start and end date. This video will show how to do that both in Power Query and in Power BI.
Debugger Poster.pptx

The DAX Debugger tool in Tabular Editor 3

Understanding and debugging your #DAX in #powerbi just got much easier and faster with the DAX Debugger tool in Tabular Editor 3. In this video, I demonstrate the tool with some DAX that doesn't give the expected result. And I show you how to use the debugger to find the cause...
Demo Time Paginated reports in Power BI - What is all the fuss about? - Microsoft Power BI Report Builder

Paginated reports in Power BI

A paginated report on a #Powerbi report page can be an excellent solution when you have a large table and want to export it to PDF, share only that table or when you want to print it. Learn all about it in this video!