Grouping or Summarizing Rows in Power Query - BI Gorilla
Grouping or Summarizing Rows in Power Query - BI Gorilla
Apr 25, 2018
gorilla.bi
Working with BigQuery Dense_Rank & Rank Functions
Working with BigQuery Dense_Rank & Rank Functions
Oct 13, 2024
hevodata.com
SQL PARTITION BY Clause overview
SQL PARTITION BY Clause overview
168 viewsApr 9, 2019
sqlshack.com
Abhishek on Instagram: "The 10 SQL Patterns That Cover 80% of Interviews (2026 Updated) 1. Running total / cumulative sum: Use `SUM(...) OVER (ORDER BY date ROWS UNBOUNDED PRECEDING)` for balances or revenue trends. 2. N-th highest / ranking: `DENSE_RANK() OVER (PARTITION BY dept ORDER BY salary DESC)` to find top salaries per group. 3. Gaps and islands: `(date - ROW_NUMBER() OVER (ORDER BY date))` groups consecutive records like active streaks. 4. Cohort retention: Group by signup cohort and pe
0:05
Abhishek on Instagram: "The 10 SQL Patterns That Cover 80% of I…
1.8K views3 weeks ago
Instagramthedataguy16
SQL Server Percentiles - How to Use percentile_cont to Group Data by Upper, Middle, and Lower Thirds
SQL Server Percentiles - How to Use percentile_cont to Group Data by …
3.1K viewsSep 2, 2020
YouTubeSean MacKenzie Data Engineering
Power BI - DAX function RANKX - Dense and Skip
Power BI - DAX function RANKX - Dense and Skip
2.9K viewsApr 14, 2022
YouTubeData For Knowledge
Learn Power BI: Window as Rank- why and Why not
Learn Power BI: Window as Rank- why and Why not
401 viewsMar 2, 2023
YouTubeLearn Microsoft Fabric, Power BI, SQL Amit Ch…
RANK COLUMN IN POWER QUERY | HOW TO CREATE RANK COLUM…
3.9K viewsSep 10, 2022
YouTubePower BI Helpline
Adding Pre-Calculated Rank in Power BI Using Power Query
Jun 17, 2022
radacad.com
11:23
SQL DENSE RANK Function
3.2K viewsDec 14, 2017
YouTubeTraining2SQL MSBI
4:14
Intermediate SQL Tutorial | Partition By
321.8K viewsDec 1, 2020
YouTubeAlex The Analyst
8:51
SQL Ranking Functions: Part 1 The Over Clause
34.5K viewsOct 12, 2017
YouTubeDatabase by Doug
11:33
Advanced RANKX - How To Understand This Function More D…
39.5K viewsJul 17, 2019
YouTubeEnterprise DNA
7:03
BigQuery Partitioning and Clustering, Explained
10.1K viewsApr 13, 2020
YouTubeCIFL
11:04
Ranking Values with Power Query
7.5K viewsAug 7, 2019
YouTubeDoug H
7:05
SQL Server Tutorial 23: Partitioning Tables and Indexes
54K viewsFeb 11, 2014
YouTubeJohnny Deluca
11:53
Power Query Running Totals - The Right Way!
85K viewsNov 24, 2020
YouTubeMyOnlineTrainingHub
12:14
Intermediate Power BI - How to rank using RankX
29.3K viewsMar 19, 2021
YouTubeWilly1987
11:12
Easily Compare Multiple Tables in Power Query
119.1K viewsAug 5, 2021
YouTubeMyOnlineTrainingHub
22:59
Compute a ranking based on multiple columns
60.2K viewsNov 23, 2020
YouTubeSQLBI
7:17
Dynamically expand table column in Power Query
18.3K viewsFeb 4, 2021
YouTubeExceed Learning
5:40
RANK function in Excel and Rank by groups by Chris Menard
102.6K viewsJan 28, 2020
YouTubeChris Menard
4:25
Ranking within a Group with Power Query
23K viewsMay 12, 2020
YouTubeDoug H
10:52
Showing Ranking in a Visual in Power BI using RANKX DAX functi…
31.6K viewsMay 25, 2021
YouTubeRADACAD
16:04
Excel Power Query Tutorial - Grouping Tables of Data
17.4K viewsAug 26, 2021
YouTubeDavid Langer
9:51
Dynamically expand table column in Power Query (advanced)
11K viewsFeb 11, 2021
YouTubeExceed Learning
19:24
Power Query Unpivot - fix 4 common data layouts (incl. workb…
256.6K viewsJun 6, 2017
YouTubeMyOnlineTrainingHub
5:00
How to Group By Maximum Value using Table.Max in Power Query
45.4K viewsFeb 3, 2021
YouTubeBI Gorilla
5:22
Easy Trick for Sorting Columns in Power Query
13.6K viewsNov 23, 2019
YouTubeHow to Excel
8:26
Power BI Row_Number Over Partition by [Column] Order by [C…
15K viewsJun 28, 2021
YouTubeLife of Business Analyst
See more videos
Static thumbnail place holder