Forum Discussion
Getting The Average For the Top 5 Results
Appreciate the reply, trying to diagnose the issue without the actual data / data model in front of you is a tough ask. In any case, it looks like I got the authority to attach now. If you have any more time to review it would be greatly appreciated.
FYI - I'm making slow inroads into figuring it out myself, I wasn't aware that you could create a table based on the DAX code i.e. EVALUATE...SUMMARIZE so I'm seeing how the data looks when it comes time to count. The main issue is trying to create that grouping by MatchID, TeamID and the totals in their last 5 games.
Thanks for sharing your wbook (haven't looked at it yet). I don't promisse anything given my level of expertise but will have a look at it
Re. I'm making slow inroads into figuring it out myself, I wasn't aware that you could create a table based on the DAX code i.e. EVALUATE
In case you don't know it there's a amazing Excel (and PowerBI) add-in called 'DAX Studio' avail. on sqlbi/Tools. This site is really a ref. IMHO