Marnix Jansen
Combine multiple excel sheets
How do you combine multiple Excel sheets in #powerbi even when the structure is different? Learn all about it in this short video!
Marnix Jansen
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…
Marnix Jansen
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.
Marnix Jansen
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.
Marnix Jansen
The DAX Debugger tool in Tabular Editor 3
Het begrijpen en debuggen van je #DAX in #powerbi is zojuist veel eenvoudiger en sneller geworden met de DAX Debugger tool in Tabular Editor 3. In deze video demonstreer ik de tool met wat DAX die niet het verwachte resultaat geeft. En ik laat zien hoe je de debugger kunt gebruiken om de oorzaak te…
