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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adityamalik1234
Frequent Visitor

Counting occurence between dates

Hi Everyone,

 

My dataset looks like: 

DateProduct
1/1/2022Table
1/1/2022Chair
1/1/2022Seat
1/1/2022Monitor
1/1/2022Monitor
1/1/2022PC
1/1/2022Laptop
1/2/2022Table
1/2/2022Chair
1/2/2022Seat
1/2/2022Monitor
1/2/2022Laptop
1/2/2022Laptop
1/2/2022Table
1/2/2022Chair

 

I would like to add a 3rd column where occurence of product is counted. The output would look like:

DateProductOccurence
1/1/2022Table1st
1/1/2022Chair1st
1/1/2022Seat1st
1/1/2022Monitor1st
1/1/2022Monitor2nd
1/1/2022PC1st
1/1/2022Laptop2nd
1/2/2022Table2nd
1/2/2022Chair2nd
1/2/2022Seat2nd
1/2/2022Monitor2nd
1/2/2022Laptop3rd
1/2/2022Laptop4th
1/2/2022Table3rd
1/2/2022Chair3rd

 

How do I achieve this in dax?

 

Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@adityamalik1234 , You can create a Rank Column

 

A new column = rankx(filter(Table, [Product] =earlier([Product]) ), [Date],,asc,dense)

 

You can append text in a new column as per need

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@adityamalik1234 , You can create a Rank Column

 

A new column = rankx(filter(Table, [Product] =earlier([Product]) ), [Date],,asc,dense)

 

You can append text in a new column as per need

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.