Select Page

DAX for a Calendar Table

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...

The art of designing a Power BI model

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 –...

Joining Tables in Power BI

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...