DST Refresh Date Function Power BI Service
Quick tip for DST Refresh Date function Power BI Service. I'll put the code up front, and explain it below. I'll also say a bit about how to use it at the end. The United States and other places, like…
2 Tips for Visualizations in Power BI Dashboard
Here are 2 tips for visualizations in Power BI Dashboard. In Power BI service (PBIS) there are reports. But there are also dashboards. Dashboards are sites to pin key visuals. People can view but not interact with them. They can click…
Automated Testing With Power Query
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…
So, You’re Getting a Data Warehouse for Power BI…
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.…
Power BI Workspaces, Apps, and Ensuring Smooth Updates to Reports
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 Get Power BI Service to Work for You
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…
Months and Trailing Twelve Months in One Table
Use a disconnected table in Power BI to show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance between the two in one matrix table. And conditional formatting!
DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)
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…
DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)
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…