Power BI Tips: CALCULATE 101

One of the most challenging and useful DAX functions to master in building complex measures and calculated columns is the CALCULATE function. In what follows I’ll describe two specific scenarios where knowing how and when to use CALCULATE is a must. My hope is that...

Power BI Tips: One Dataset to rule them all!

In the Power BI Desktop August Feature Summary (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/) Microsoft announced the “live connect” Power BI Service connector is generally available. Now everyone can start using this feature...

Learn DAX for Power BI

5 Step Plan to Learn DAX for Power BI In my as-yet-incomplete journey to master the DAX language for solving problems in Power BI, I have come across a few resources that, when consumed in the right order and at the right time, provide a good guide for learning how to...