topic Replace repeating/duplicate values with null/blank() in DAX Commands and Tips

Replace repeating/duplicate values with null/blank()

Anonymous — Sat, 09 May 2020 19:51:21 GMT

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.

Greg_Deckler — Sat, 09 May 2020 20:02:28 GMT

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

Anonymous — Sat, 09 May 2020 20:22:06 GMT

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

Greg_Deckler — Sat, 09 May 2020 23:35:21 GMT

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)

rohitpoojari — Wed, 23 Oct 2024 09:30:16 GMT

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