by gene connolly | Dec 8, 2017 | Power BI |
When the data you “Get” in Power BI doesn’t come in nicely organized rows and columns, sometimes you need to do more with “Edit Queries” than just using the functions available on the ribbon. And that’s when you need bust out some “M” code to get the job done. In what...
by gene connolly | Nov 22, 2017 | Power BI, Uncategorized |
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...
by gene connolly | Nov 8, 2017 | Power BI |
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...
by gene connolly | Nov 2, 2017 | Power BI |
I recently had to come up with a solution for a customer requirement to change the displayed measure as each level of a hierarchy changed by drill down through a column chart. Yikes! But with a little help from the Power BI Community, here’s the solution. For example,...
by gene connolly | Dec 1, 2016 | Power BI |
I recently needed to solve this problem, and thought it was worth sharing as a Power BI DAX “go by” for others. The Situation The situation was creating Power BI dashboards for sales pipeline data coming from a CRM system. In this CRM data model, “Opportunities” have...
by gene connolly | Nov 30, 2016 | 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...
