Complex transformations: get previous row value - Advanced POWER QUERY

  Рет қаралды 1,099

Data Analytics Central

Data Analytics Central

Жыл бұрын

In this video, we dive into a practical business case that showcases a complex transformation using Index columns in Power Query. Learn how to leverage the power of Power Query to access the previous row value and perform intricate data manipulations with ease.
🔔 Don't forget to subscribe to our channel for more insightful content on data transformations and analytics.
🎯 Looking to take your skills to the next level? This is just one lesson from our comprehensive course on Power Query, where we'll explore in-depth techniques and real-world scenarios. Please write in the comments if you want to be among the first to access the complete course.
📚 Course Highlights:
- Master advanced data transformation techniques using Power Query
Gain a deep understanding of complex transformations, including accessing previous row values
- Explore practical business cases and real-world examples
- Unlock the full potential of Power Query for data analysis and manipulation
Be prepared to take your data analytics journey to new heights!
#PowerQuery #DataTransformation #DataAnalytics #datamanipulation #etl

Пікірлер: 7
@FUN-es8zo
@FUN-es8zo Жыл бұрын
Good
@Data.Analytics.Central
@Data.Analytics.Central Жыл бұрын
Thanks for the appreciation!
@jayintheweeds2629
@jayintheweeds2629 6 ай бұрын
I accomplished something similar using a custom column with complex formula that slowed pq down so much. Your method was so much better! Thank you!
@Data.Analytics.Central
@Data.Analytics.Central 5 ай бұрын
Thanks for the feedback! 🤝
@deyscube577
@deyscube577 11 ай бұрын
Such a lovely video .good things take time..we are with you..carry on with some different beautiful work in power bi love❤
@Data.Analytics.Central
@Data.Analytics.Central 11 ай бұрын
Thanks a lot for the appreciation! 🙏
@tanweerabbasabbas649
@tanweerabbasabbas649 10 ай бұрын
no data file attached.???
Return Previous Row Value in Power query
9:57
BI Gorilla
Рет қаралды 25 М.
Survival skills: A great idea with duct tape #survival #lifehacks #camping
00:27
Cat Corn?! 🙀 #cat #cute #catlover
00:54
Stocat
Рет қаралды 15 МЛН
Red❤️+Green💚=
00:38
ISSEI / いっせい
Рет қаралды 64 МЛН
Advanced Power Query - Unpivot Columns with Multiple Headers
5:19
Data Analytics Central
Рет қаралды 10 М.
2 - Data Transformation - Dashboard in a Day #powerbi
16:12
Data Analytics Central
Рет қаралды 115
Calcul des heures décimales supp à 24h
3:11
HackHive
Рет қаралды 19
The New LINESTX() DAX Function in Power BI - Clearly Explained #linearregression
8:20
Become a Data Ninja with Power Query and Power Pivot #powerquery #powerpivot
3:15
A simple example of ETL (Extract, transform, and load)
11:42
Isaac Vaghefi
Рет қаралды 30 М.
Excel Power Query Course: Power Query Tutorial for Beginners
1:49:28
Simon Sez IT
Рет қаралды 817 М.
List.Generate() Function and Looping in PowerQuery
23:56
Exceed Learning
Рет қаралды 24 М.
$1 vs $100,000 Slow Motion Camera!
0:44
Hafu Go
Рет қаралды 23 МЛН
СТРАШНЫЙ ВИРУС НА МАКБУК
0:39
Кринжовый чел
Рет қаралды 1 МЛН
Хотела заскамить на Айфон!😱📱(@gertieinar)
0:21
Взрывная История
Рет қаралды 6 МЛН