Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Tagging-Videos-For-each-session/m-p/215464#M95350
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |