Grain Shifting Calculations in Power BI (The “Repeating Shipping Costs” Problem)

Each row in your table is a transaction, but your table also includes things like shipping fees. While there is a shipping feel listed for each transaction, the number repeats for every row because it actually only makes sense for the order as a whole. Summing up that column would double, triple, and quadruple count the fee resulting in wildly incorrect answers. In this video I’m going to not only walk you through the surprisingly simple way this problem is solved, I’ll also walk you through how to understand the solution and even use DAX to visualize it on the page.

Click here to download the PBIX companion file

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.