Power Query Challenge 01 - Transform Cumulative Sums to Individual Values (Step-by-Step Tutorial)
HTML-код
- Опубликовано: 15 июл 2024
- Power Query Challenge 01 - Transform Cumulative Sums to Individual Values (Step-by-Step Tutorial)
Welcome to an exciting Power Query Challenge presented by Microsoft MVP Vijai A. Verma!
In this tutorial, you'll learn how to transform a problem table into a result table by converting cumulative sums into individual values. This challenge is a fantastic way to enhance your Power Query skills beyond the basics.
'Excel Explained: Basics' Playlist:
• EXCEL: BASICS
Links:
Vijai A.Verma:
1) LinkedIn Profile: / excelbi
2) Power Query Challenge: / urn:li:activity:721049...
3) Download Practice File: lnkd.in/dFxC6gsG
Timestamps:
00:00 - Introduction to the Power Query Challenge
00:13 - Overview of the problem and result tables
00:33 - Step 1: Unpivot other columns
00:56 - Step 2: Add an index column
01:04 - Step 3: Calculate individual values with custom columns
01:39 - Step 4: Handling errors in the first row
01:56 - Step 5: Removing unnecessary columns
02:02 - Step 6: Pivoting the attribute column
02:13 - Step 7: Final result and conclusion
#PowerQuery #MicrosoftExcel #DataTransformation #ExcelTips #PowerQueryChallenge #DataAnalysis #ExcelMVP #ExcelTutorial #CumulativeSum
Great series.... kindly continue this and bring new challenges
I'm planning to create a regular series on the channel. There's plenty of material to work with, but I want to avoid it becoming repetitive.