Distribution of ranking over time

[BIfanatic]

Hi everyone,

I am looking for a way to help a client. There is one big transaction table, with different suppliers. It looks like this:

Date	Transaction time	Supplier	Sales	Revenue
27-5-2019	12:45	X	2	10

I would like to determine a ranking of who sold the earliest for each day. So every supplier gets a ranking from 1 to last.

Then I would like to see how they scored over time. So, how is the distribution of this ranking? Is it evenly distributed, or skewed for any of the suppliers?

Do you guys have any clue how to solve this specific task with DAX or M?

Thanks in advance for your help.

[v-chuncz-msft]

@BIfanatic ,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Tagging-Videos-For-each-session/m-p/215464#M95350

[BIfanatic]

Thanks @v-chuncz-msft,  but what if I have more than 1 transaction for each supplier? I would only like to rank the earliest transaction time per date. Is it possible in this fact table, or do I need to summarize first?