Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Not sure if this makes sense...
For example, looking to get the total points a player scored on the first date that player scored points for each player in the table.
Then looking to have a graph which would compare each players total points on the first day, second day, third day etc. So the graph stores the minimum dates as the same value, despite each players potentially being different.
Not sure if this is even possible at all but thought I'd give this a try anyway!
Create a rank column like this
Rank = RANKX(all(Table[player]),Table[date],,DESC,asc)
This will act like 1,2,3 day for each play. Now you can compare them
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
can you provide some data or dummy data?
Proud to be a Super User!
it will but better if you provided it in text form?
Proud to be a Super User!
@vanessafvg sorry!
Players | Points | Date |
a | 31 | 21/10/2019 |
b | 20 | 15/08/2019 |
c | 61 | 31/01/2020 |
b | 27 | 07/09/2019 |
c | 40 | 08/01/2020 |
b | 90 | 06/10/2019 |
b | 57 | 16/12/2019 |
b | 46 | 23/11/2019 |
b | 37 | 21/08/2019 |
a | 52 | 06/12/2019 |
Players | Points | Day |
a | 31 | 1 |
b | 20 | 1 |
c | 40 | 1 |
a | 52 | 2 |
b | 37 | 2 |
c | 61 | 2 |
Also the results should continue on for each day after when the player scores points
@Bats not sure if this helps
Proud to be a Super User!
@vanessafvg It's close although didn't quite work with my actual dataset as all the players had the same rank for some reason. But did work in the sample dataset. However, would it be possible to get the RANK as row/column/to be used as an axis?
@Bats can you give me an idea of how you using this, or show me, its hard to do this without all the information maybe just screen shot an example or show me what you expecting with the fields
Proud to be a Super User!
@Bats definitely think it would be possible as long as model your data correctly, and store the right amount of data. Incuding things like date table.
what is your data model?
Proud to be a Super User!
@vanessafvg Using SSAS tabular model. Has Date table, Player table, and a Points table. Points table containing DateIDs and PlayerIDs.
Thanks!
User | Count |
---|---|
134 | |
71 | |
70 | |
54 | |
52 |
User | Count |
---|---|
205 | |
95 | |
63 | |
61 | |
54 |