This is a quick tip on automated testing with Power Query. I loved Nar's post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For…
Data Warehouses: What Do I Know? Well, I'm no expert. I learned Power Pivot and Power BI through Excel. What I know is from helping to build a SQL data warehouse. That is, I've worked with a data warehouse pro.…
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…
What I didn't know about the Power BI Service (PBIS): I've been using the Power BI Service (PBIS) daily for five months, and before that, I consulted on challenging DAX problems for over a year. So, when I attended a…
Today, I'll show you how to bring the awesome to moving averages with DAX text formulas for slicers and titles... and yes, I'll throw in a Greatest Formula In the World (GFITW) version, too. In Part One, I used What-if-parameters…
In 2013, Rob showed how to use a disconnected table and slicer to show moving averages with a variable time period. That post built on an earlier post, which steps through the process of creating moving averages. What-If-Parameters, teased at…