Self-service data analysis with Microsoft Power BI.
One of the most powerful features (and there are lots) that I’ve found about Power Query is the ability to hold an entire table in a single cell. Once I’ve got a table in a cell, then I can start…
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…
Adding Visual Flair In Power BI With Background Colors Hello P3 Nation! Today’s “post” is going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and…
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,…
Conditional Formatting Using Text In Power BI Desktop Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and…
Today, we'll look at Power BI workspaces, apps, and how to keep changes from mucking up reports. In the software development lifecycle, a distinct space to test new reports ensures consistent results. Moreover, it's part of good governance. This post builds…
How to Create A Real Time Dataset on Power BI.com Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written…
Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project. Another great trilogy comes to an end… well at least until the next one comes out. If you haven’t “seen” part 1 & part 2, go…
Hello P3 Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe. It’s like Christmas each month for us here at PowerPivotPro, where…
My name is Mathew Herring Jack, and I am a member of Traditional Excel Users Anonymous. As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting,…