Forum Discussion
Replace repeating/duplicate values with null/blank()
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...
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)
Create an Index column in Power Query editor. Now you have something to reference.
I am new to power BI. What would the DAX formula for replacing duplicate values look like?
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)