Replace repeating/duplicate values with null/blank()

[Anonymous]

How do I replace all but one repeating/duplicate values in overtime column with null? There are no unique columns to cross reference to.

Thanks.

https://i.imgur.com/SELU4wz.png

https://i.ibb.co/9sfJrC2/Untitled.png

[rohitpoojari]

Can this be done in Query Editor? replacing the subsequent duplicated value with null

[Greg_Deckler]

Create an Index column in Power Query editor. Now you have something to reference.

[Anonymous]

I am new to power BI. What would the DAX formula for replacing duplicate values look like?

[Greg_Deckler · Accepted solution]

Oh, well if you had an index it would look something along the lines of:

New Column =

  VAR __Value = 'Table'[Overtime]

  VAR __CurrentIndex = 'Table'[Index]

RETURN

  IF(MAXX(FILTER('Table',[Index] = __CurrentIndex - 1),[Overtime])=__Value,BLANK(),__Value)