Forum Discussion
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...
If you're using 365:
ID = Column A
Data = Columns A and B
=LET(
CheckIDs, LAMBDA(row,
LET(records, UNIQUE(FILTER(DATA, ID = row)), ROWS(records) = 1)
),
BYROW(ID, CheckIDs)
)
- Is this a DAX formula in power query editor in power bi?
