Find and index duplicate figures in Power BI and Power Query

preview_player
Показать описание
How to find duplicate rows in a table and add a nested index to each duplicate row.

  1. The BIccountant
  2. Power BI
  3. Power Query
  4. Duplicate
  5. Nested Index
Рекомендации по теме
Find and index 0:07:24

Find and index duplicate figures in Power BI and Power Query

Three EASY Ways 0:08:56

Three EASY Ways to Find and Remove Duplicates in Excel

Vlookup with Duplicate 0:06:23

Vlookup with Duplicate Entries

Index Match with 0:07:45

Index Match with Multiple Criteria

Find the Duplicate 0:17:34

Find the Duplicate Number - Floyd's Cycle Detection - Leetcode 287 - Python

Return Multiple Match 0:14:13

Return Multiple Match Results in Excel (2 methods)

Excel - Conditional 0:03:36

Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard

Python program to 0:03:59

Python program to print duplicate values in a list tutorial | Duplicate elements

How to Rank 0:13:18

How to Rank Duplicate Values in Excel without Skipping Numbers (Top 3 Report with Duplicates)

Solved - How 0:10:24

Solved - How To Get Results based on Duplicate Lookup Value in VLOOKUP - Excel

Video 7: How 0:04:19

Video 7: How to run calculations on indexes with duplicate values

Lookup and Find 0:12:20

Lookup and Find the 2nd, 3rd, or the Nth Matching Value in Excel

Consolidate Data in 0:05:27

Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet

Java program to 0:07:56

Java program to find the duplicate elements in the array using index

Prevent Duplicate Entries 0:01:45

Prevent Duplicate Entries in Excel - Tutorial

Create an Interactive 0:06:44

Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function

Stop using VLOOKUP 0:11:05

Stop using VLOOKUP in Excel. Switch to INDEX MATCH

how to find duplicate values 0:11:42

how to find duplicate values in excel using vlookup

Array - 46: 0:07:24

Array - 46: Find Duplicate value present in 1 to n numbers range

Find the duplicate 0:18:14

Find the duplicate number (LeetCode 287) | Full solution with different methods | Study Algorithms

Find Duplicate Values 0:03:49

Find Duplicate Values in Power BI

How to find 0:02:51

How to find duplicate values in Excel using Vlookup

Find duplicate values 0:01:18

Find duplicate values using IF condition in Excel

Find the Duplicate 0:10:56

Find the Duplicate Number | Leetcode 287 | 4 Approaches 🔥🔥 | Live coding session

Комментарии
Автор

Very elegant solution. Thank you for posting. I will definitely come back to your channel.

YvesAustin
Автор

Lmke I was taking a totally different approach to dealing with duplicates and just did not consider this very simple approach. wow, thank you

jeffbrady
Автор

You just saved me 01 week of work. Thanks!

marcelodiniz
Автор

Thank-you for making this video. You're very kind and knowledgeable.

ozGold
Автор

Thank you so much for the wonderful posting Imke. Your trick solved a problem I've been struggling with for a week.

ihp
Автор

When I get to the Expand step, the new CountMultiple column is not an option. Why not?

renoyoung
Автор

Thank you SO much. This is exactly what I've been looking for.

eric_villagomez
Автор

This video just helped me out so much. Thank you!

tstine
Автор

Thanks, you are a god! You just saved me so much time, I think now i can solve my problem :)

lukasseifriedsberger
Автор

I am so happy I found this Video, Thank you for sharing Imke

MarkCBB
Автор

Hi! Whats does the "_" (underscore) stands for in the code added to the group by function?.
It's just for further understanding of the sintaxis, but the solution worked wonderful.
Thanks!!

alexismetaute
Автор

When I go to expand the partition there is no option in the drop down to tick "CountMultiple"? Any ideas? :/

juliuspope
Автор

There is no edit Queries Button. Where can I find it?

sandrafichtl
Автор

Greetings from Colombia
If I could give you 1.000 likes i will do it now
Thank

sergiomira