Forum Discussion

NeilTJustice's avatar
NeilTJustice
Copper Contributor
Aug 28, 2023

Duplicates in one column with different values in another column

I have a table that has a column with a range of values that are not unique, i want to find the values that are the same in column A then see what it returns in column B if all the values in column B...
excel
Formulas and Functions
office 365
power bi
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Aug 28, 2023

NeilTJustice 

 

=LET(
a,UNIQUE(A$2:B$8,,TRUE),
b,CHOOSECOLS(a,1),
c,CHOOSECOLS(a,2),
d,FILTER(c,b=A2,B2),
d)

 

  • neiltownend1510's avatar
    neiltownend1510
    Copper Contributor
    Aug 30, 2023
    Is this a DAX formula in power query editor for power Bi?
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Aug 30, 2023
      It's neither. It's an Excel formula.

Resources