Fred Kaffenberger, Author at PowerPivotPro

Fred Kaffenberger

A teacher at heart, Fred loves that moment when someone struggling to solve a problem makes a breakthrough. Fred spent six years in client services and sales for an online work order system. After this, he used Excel to help streamline commercial real estate operations for a major telecommunications carrier, where he discovered Power Pivot and Power BI. He was thrilled at how these tools helped him work smarter and more systematically. As an English major, Fred knows that a knack for working with data can surface in surprising places.

Power Query (M)agic: Parameters for Dataflows!

I'll get to parameters for dataflows in a bit. To begin, let's talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service. They are…

Read the Rest

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…

Read the Rest

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…

Read the Rest

Automated Testing With Power Query

November 3, 2018
Fred Kaffenberger
M Code, Power Query, Quick Tips & Tricks
2 Comments

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…

Read the Rest

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.…

Read the Rest

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…

Read the Rest

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…

Read the Rest

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!

Read the Rest

DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)

November 7, 2017
Fred Kaffenberger
DAX, Downloads, Power BI, Slicers and Disconnected Slicers, Time Intelligence
10 Comments

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…

Read the Rest

DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)

August 30, 2017
Fred Kaffenberger
DAX, Downloads, Power BI, Slicers and Disconnected Slicers
17 Comments

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…

Read the Rest