Power query tricky question

[vjnvinod]

Dear community.

I have a table whose coloumns are below

Source.Name

Fiscal year

Account

AccountChannel

AccountSegment

AccountSubSegment

AccountSector

AccountSubSector

1Area

1Region

GCSP

1Country

ServiceLine

SubServiceLine

TER_FYTD_USD

TER_FYTD_Constant

RevenuePlanFY_Constant

NER_FYTD_Constant

MarginFYTD_Constant

MarginPFYTD_Constant

TER_PFYTD_Constant

SaleFYTD_constant

PipelineWeightedOpen_constant

Region

I need to create additional coloumn with a condition that, if all of my row data matches except for category, then i want that to show it as duplicate

For instance, if there are  3 duplicate rows, then it should show 2 rows as duplicate and 1 row as original.

let me know how to achieve this in power query