Скачать или смотреть MODIFYING FILTER CONTEXT TO CALCULATE INDEXES IN POWER QUERY | Q&A: Solved

In this video, I show you how to calculate total sales and relative percentages directly in Power Query using M language functions, without relying only on DAX in Power BI. I start by creating a custom column that applies the List.Sum function to reference the entire sales column, converting text values into decimals to ensure proper aggregation. Then, I demonstrate how to divide each product’s sales by the global total to compute percentages, making it easier to analyze indexes and sales contribution. I also present a second, simpler method using a duplicated table to generate a scalar value for the total, which can be merged back into the main table for calculations. These approaches give you flexibility to handle aggregation, context modification, and percentage calculations efficiently inside Power Query, preparing your data for deeper analysis in Power BI.

📈 Get the data packs: https://immalytics.com/packs?utm_sour...

🟣 DAX Foundations Playlist: 👉🏻    • DAX FOUNDATIONS  
🟢 Power Query Fundamentals Playlist: 👉🏻    • POWER QUERY COMPLETE FREE COURSE  
🟡 Power BI Playlist: 👉🏻    • POWER BI FROM A TO Z  

💻 For all playlists, visit our website: https://immalytics.com

Chapters:
00:00 Answering a student’s question about reproducing Power BI results in Power Query
00:18 Reviewing aggregation and summarization concepts before moving into context modification
00:50 Creating a calculated column in Power Query to display the total sales across all rows
01:40 Converting sales data from text to decimal and applying the List.Sum function
02:55 Calculating product percentages by dividing each row’s sales by the overall total
04:40 Alternative method: duplicating the table, summing the sales column, and merging results
06:20 Building a simpler custom column to calculate totals and percentages in one step
07:30 Finalizing results, formatting percentages, and preparing data for Power BI

#dax #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse #sql #sqlserver