Forum Discussion
Solved
Counting occurence between dates
Hi Everyone, My dataset looks like: Date Product 1/1/2022 Table 1/1/2022 Chair 1/1/2022 Seat 1/1/2022 Monitor 1/1/2022 Monitor 1/1/2022 PC 1/1/2022 Laptop 1/2...
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
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