Reply
Thomas897
Helper I
Helper I

Count duplicates

Hello everyone,

 

I want to show how many times my column 'number' appears compared to my column 'week'. Someone could help me please.

 

pib.png

 

Have a great day 🙂

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

 

Copy Number twice into your table, then make the 2nd Number a 'Count'.

 

FOrrest

 

Capture.PNG

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @Thomas897,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
fhill
Resident Rockstar
Resident Rockstar

 

Copy Number twice into your table, then make the 2nd Number a 'Count'.

 

FOrrest

 

Capture.PNG

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)