by Marnix Jansen | Jul 13, 2020 | Geen categorie
When you're managing your projects in Power BI, I can highly recommend the Gantt chart by MAQ software. You can download it for free and it is extremely easy to use. All you need to do is enter the name of your projects, the start date and the end date and you're good...
by Marnix Jansen | Jul 10, 2020 | Geen categorie
Since I receive questions about this topic from my clients I decided to dedicate a blog to it. What is the difference between DATEADD and PREVIOUSMONTH? Isn't the result the same? The answer is that it sometimes is, but certainly not always. In this scenario, the...
by Marnix Jansen | May 28, 2020 | Geen categorie
Door de kracht van Power BI en Power Apps te combineren kan het forecast proces veel robuuster, transparanter en efficiënter worden ingericht. In deze video, gegeven tijdens een webinar aan 160 deelnemers bij Agium, demonstreert Marnix hoe dit in zijn werk gaat....
by Marnix Jansen | Feb 24, 2020 | Geen categorie
In order to perform time-based analysis in your Power BI model, you need a separate calendar table. If you have one available in your source, Plan A is to bring that in and use it in your model. But if there isn't one available, Plan B is to create one from scratch in...
by Marnix Jansen | Jan 20, 2020 | Geen categorie
Before you start building a new Power BI model, it is crucial to first establish the context. I have facilitated many Lean VSM (Value Stream Mapping) initiatives in order to make a process (more) lean. I have learned and loved the SIPOC (Supplier – Input – Process –...
by Marnix Jansen | Jan 20, 2020 | Geen categorie
These are the 4 varieties of table joins in Power BI, given in M (Query Editor) and their equivalents in DAX. I initially created this one-pager as a reference for myself but would like to share it with all my Power BI friends out...
