Marnix Jansen
Power BI DAX: DATEADD vs. PREVIOUSMONTH
Since I get questions from my clients about this topic, 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 sometimes it is, but certainly not always. In this scenario, the result at the monthly level is the same Here's [...]
Marnix Jansen
Turboboost your forecast process with Power BI and Power Apps
By combining the power of Power BI and Power Apps, the forecast process can be made much more robust, transparent and efficient.
Marnix Jansen
DAX for a calendar table
Most Power BI models require a date table. Just add a new table to your model and copy-paste this code to get one.
Marnix Jansen
The art of designing a Power BI model
Before you start building a new Power BI model, it is crucial to establish the context first. I have facilitated many Lean VSM (Value Stream Mapping) initiatives to make a process (more) lean. I have learned the SIPOC (Supplier - Input - Process - Output - Client) approach as [...]
Marnix Jansen
Merging tables in Power BI
These are the 4 variants 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 there.
