cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Azat Regular Visitor
Regular Visitor

indexing

Hi everyone,

I have a problem and cannot solve

We have 2 offline shops, Shop A and Shop B, every shop have its own sales sorted by date.

I want to index that sales by date and by shop. 

 

example:

Shop name     Date                       Index

Shop A           15/12/18 12:14         1

Shop B           15/12/18 13:55         1

Shop A           15/12/18 19:00         2

Shop A           16/12/18 10:11         3

Shop A           16/12/18 10:14         4

Shop B           16/12/18 14:20         2

Shop A           16/12/18 18:30         5

Shop B           17/12/18 17:50         3

Shop A           18/12/18 12:01         6

 

......

 

Thanks for any help

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: indexing

@Azat

 

One way could be to use  a calculated column

 

Column =
RANKX ( FILTER ( Table1, [Shop name] = EARLIER ( [Shop name] ) ), [Date],, ASC )

View solution in original post

2 REPLIES 2
Super User
Super User

Re: indexing

@Azat

 

One way could be to use  a calculated column

 

Column =
RANKX ( FILTER ( Table1, [Shop name] = EARLIER ( [Shop name] ) ), [Date],, ASC )

View solution in original post

Azat Regular Visitor
Regular Visitor

Re: indexing

thank you, appreciate

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 347 members 3,357 guests
Please welcome our newest community members: