Name: Excel Users Struggle with These Calculations in Power BI – Here’s the Fix!
Uploaded: 2026-01-13T17:32:40.583Z
Duration: 1183 s
Description: This video demonstrates how to translate common Excel calculations, specifically contribution analysis (calculating the percentage mix of items against a total), into Power BI. It provides two methods: using Power BI's "Visual Calculations" feature and using DAX formulas.

AI Commentary

Play the video to see AI commentary

Oh, so the speaker's at the Global Excel Summit and has been chatting with some real Excel bigwigs! It's cool they're drawing inspiration from these interactions to tackle common calculation challenges for Excel users moving to Power BI.

This sets up a really common pain point – trying to replicate familiar Excel logic in a new tool. I'm already curious to see what kind of calculations they're referring to and how Power BI handles them differently.

Okay, so the scenario starts with a simple Excel-style percentage calculation. Dividing $188,000 by the combined total of $49,000 to get 37% and 63% – that's straightforward enough for a basic overall percentage.

Want more insights? Sign up to see the full conversation

Video summary will appear here after you start watching

The speaker begins by highlighting a common challenge for Excel users transitioning to Power BI: replicating specific calculations, using the example of year-over-year percentage calculations [0:00]. He recounts attending the global Excel Summit and meeting prominent Excel users, framing this experience as the inspiration for addressing these translation issues [0:10]. The core problem identified is the difference in how Excel and Power BI handle grand totals for percentage calculations.

Want to access full features?

Current Section Summary

Video summary will appear here after you start watching

Want to access full features?

Excel Users Struggle with These - AI Video Analysis

AI Commentary

Current Section Summary