Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

New Column to Check if Duplicate, Add Marking

Hi there,

 

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

aidelsrkk_0-1629861250545.png

 

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.

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@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)
 
1.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@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)
 
1.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Works like a charm! Thank you!

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.