New Column to Check if Duplicate, Add Marking

[Anonymous]

Hi there,

Im trying to build a column to check duplication of invoice invoice number. The result can be as follows:

I tried the posting here, https://community.powerbi.com/t5/Desktop/Add-column-where-the-first-duplicate-value-gets-value-1-and... , but it doesnt work.

Thank you.

[ryan_mayu · Accepted solution]

@Anonymous 

pls try this

Column =

VAR _count=CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[Invoice No]=EARLIER('Table'[Invoice No])))

return if(ISBLANK(_count),'Table'[Invoice No],'Table'[Invoice No]&"-"&_count)

[Anonymous]

Works like a charm! Thank you!

[ryan_mayu]

you are welcome