by Patrick Mahoney | Jul 17, 2018 | PowerPivotPro
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,… This post first appeared...
by Chris Webb | Jul 16, 2018 | Chris Webb
Troubleshooting Power Query performance issues in Power BI and Excel can be difficult because it’s a bit of a black box: there’s nothing in the UI to tell you what’s going on inside the Power Query engine and the diagnostic logs are very difficult to interpret. With...
by Matt Allington | Jul 16, 2018 | Excelerator BI
Level: Intermediate I do lots of live training, face to face and online, and I always encourage students to bring along any business problems they would like some help with. Last week I had a great problem that Debbie shared with me that I thought was worth creating...
by Jeanne Combrinck | Jul 16, 2018 | SQL Girl
Lets start off with what is a table-valued function (TVF)? A TVF is a dynamic table produced at the time of execution, depending on parameters. Like a view, a TVF creates a result set only when it’s executed, but, unlike a view, it can be parameterized. You get two...
by Gil Raviv | Jul 12, 2018 | Data Chant
In today’s short post, I would like to share with you the Table of Contents of my book, Collect, Combine and Transform Data Using Power Query in Excel and Power BI. (You can pre-order the book on Amazon here or on Microsoft Press Store here). This post first appeared...
