We were recently building a data model with on-prem Dynamics data mostly using the OData feed (v8.2). This article only scratches the surface of what is possible with OData (including update/write functions and much more complex queries than those shown…
Power BI comes stocked with a great set of visuals that keep getting better (more options to do multiples, please). Even when the default set isn't enough, there is also a great collection of additional visuals you can find in…
In Part I, we used the query editor and the M List functions to generate all the possible combinations of five and seven cards from a standard deck. To score all the possible combinations of seven cards (133M possible hands…
Last month I saw a puzzle posted on fivethirtyeight.com about poker hand probabilities and, like with many things these days, wondered how I could solve it with PowerBI. I had been curious to learn more about the M list functions,…
It's time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI. This article explains one approach for doing March Madness Power BI style, and using everyone's bracket data to teach…
As a 'water cooler' of sorts for this community, we meet some amazing people. Patrick Mahoney has been inspiring his local community to leverage modern excel and shares with us a really useful technique to create a dynamic dimension table…