Get True false when duplicate in a row is find in direct query

[Poornima2023]

I have below data

Name	ID	Age	Key(concatenated name and id)	Duplicate
A	6	12	A6	False
A	6	4	A6	True
B	1	5	B1	False
C	9	6	C9	False
C	9	2	C9	True
D	3	3	D3	False

[Poornima2023]

Not able to open link

[dufoq3]

[dufoq3]

Hi @Poornima2023,

Result

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTIDYkMjIOFophSrgxAzQQg5gZQAsSkQOxmChZyBTEuoSmdLFCEjhJALkGkMxS7GSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, ID = _t, Age = _t, Key = _t]),
    GroupedRows = Table.Group(Source, {"Key"}, {{"All", each Table.RemoveColumns(Table.AddColumn(Table.AddIndexColumn(_, "Index", 0, 1), "Duplicate", (x)=> if x[Index] = 0 then false else true, type logical), {"Index"}), type table}}),
    Combined = Table.Combine(GroupedRows[All])
in
    Combined

[Poornima2023]

will it work in power bi?

[dufoq3]

Yes, of cource. If you don't know how to use my query --> Read note below my post.

[Poornima2023]

Its not working as my data is directquery mode