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.
Hello everyone,
This is my first post and the beginning of my adventure with dax so please be understanding. I have a table with 3 columns: index, score and player. I try to count the average score of the last 30 indexes for each player. I have over 14,000 lines and over 300 players so for each player the last 30 indexes will be different.
Thank you for all the great content you have here - it is a great place to learn 🙂
Solved! Go to Solution.
@Pan_Forex , Create an index column in table using DAX
index= rankx(filter(Table, [Player] = earlier([Player]) ), [id],,asc,desc)
Create a new table
series = generateseries(Min(Table[index]), Max(Table[index]) ,1)
then create join series[value] with rank and create a measure
calculate(average(Table[game_score]), filter(all(series) , series[Value] >= max(series[Value]) -30 && series[Value] <= max(series[Value]) ))
Hi, @Pan_Forex Can you provide sample data with sensitive data removed
@Pan_Forex , Create an index column in table using DAX
index= rankx(filter(Table, [Player] = earlier([Player]) ), [id],,asc,desc)
Create a new table
series = generateseries(Min(Table[index]), Max(Table[index]) ,1)
then create join series[value] with rank and create a measure
calculate(average(Table[game_score]), filter(all(series) , series[Value] >= max(series[Value]) -30 && series[Value] <= max(series[Value]) ))
Hi, thank you very much for your reply! When creating an index column, it displays an error: Unexpected value of the TIES argument in the RANKX function. The allowed values are SKIP and DENSE.
My function looks like this:
index = rankx(FILTER('public players', [Player] = earlier([Player]) ), [id],,asc,desc)
I fixed the errors, corrected the relationships and everything works. Thank you very much!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |