[Power Query] Combine only DISTINCT values

preview_player
Показать описание
  1. Short Excel
  2. [Power Query] Combine only unique values
Рекомендации по теме
[Power Query] Combine 0:03:40

[Power Query] Combine only DISTINCT values

Creating new Power 0:04:59

Creating new Power BI Table by Combining Distinct Values from Multiple Tables

Concatenate Text Values 0:04:24

Concatenate Text Values using Group by in Power Query (w/ Optional Delimiter)

Combine all unique 0:04:56

Combine all unique values within group | Excel Power Query 04

Power BI - 0:00:59

Power BI - DAX - ALL Function - How to create a list of unique values

Merge Duplicate Rows 0:04:51

Merge Duplicate Rows in Excel Combining Unique Values in One Cell

Remove duplicates without 0:04:18

Remove duplicates without losing any info | Excel Power Query

PowerQuery - GroupBy, 0:05:19

PowerQuery - GroupBy, List.Distinct

From SQL to 0:08:14

From SQL to DAX: Volkswagen's Toughest Power BI Interview Questions with Answers Revealed

Create a Unique 0:14:28

Create a Unique List from multiple data lists, Append Data, Remove Duplicates - POWER QUERY

Count of Unique 0:05:29

Count of Unique Values DistinctCount in Power BI Through Power Query Group By Transformation

Using Power Query 0:04:42

Using Power Query to Combine Multiple Tables and Remove Duplicates | Everyday Office

30. Count Distinct 0:01:36

30. Count Distinct Values | Power Query Editor

[Power Query] How 0:01:42

[Power Query] How to Extract Unique Values From Multiple Columns In Excel?

Power Query Keep 0:00:49

Power Query Keep Unique

Display Duplicates or 0:07:57

Display Duplicates or Unique Values Using Power Query | 2021

Building relationships between 0:06:14

Building relationships between tables when both have duplicates

Creating new Power 0:08:49

Creating new Power BI Table based on unique column value or duplicate column value of existing table

How To Easily 0:09:35

How To Easily Merge Tables With Power Query: Vlookup Alternative

You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

Create a New 0:07:20

Create a New Table with Distinct values from Another Table using Power Query.

Master PowerBI's Unique 0:03:33

Master PowerBI's Unique ID Extraction from Multiple Tables (PowerQuery & DAX)

Keep most recent 0:02:16

Keep most recent record on a table with Power Query | Improved solution

Microsoft Power Query 0:04:45

Microsoft Power Query - Grouping on single and multiple columns

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

this video delivers the solution of a problem I have desperately been looking for for a long time !
Thank you very much !

johanneskeller
Автор

The best speechless Power Query education channel👍

kebincui
Автор

Cool!
Only thing is, is that you should re-name this to "Combine only DISTINCT values" - because distinct values are those in the Union of the set - that is, all values which appear AT LEAST ONCE - and you want them to appear in your list only once.

Unique values, on the other hand, are THOSE VALUES which ONLY APPEAR ONCE in your set.

Therefore, the difference between distinct values and unique values are all those values which appear MORE THAN ONCE in your list - that is, all those values which have duplicates.

JJ_TheGreat
Автор

Tanks about your sample file
i can practice to study
thanks

sumardjo
Автор

We need more why same videos was stopped??

SamehRSameh
Автор

Great. Perfect teaching without saying a single word. I would like to see this result putting the first column as the header and the corresponding distinct values in its columns. I've tried everything within my little knowledge and still not succeed. Here is from Brazil.

carlosrsantana