I hope someone here with better Excel skills than me can help.
I maintain an Excel file which is used by Power BI to provide weekly status of a Fantasy Football (Soccer) league operating at my place of work. There is one tab in the Excel that has 4 columns, the first is the game week number which repeats the same value 69 times from 1 to 38, the second is is the ID number for each team 1-69 so for each game week all teams have a row, the third column is the total points per team (manually updated once a week) and the fourth column is the points scored in the most recent week (formula taking previous week score from current).
In Power BI we are able to report the 3 highest ever weekly scores, however when trying to show in which week the score was achieved my filtering for top 3 stops working.
I would like to create a separate tab in my Excel which will show the maximum points scored for each of the 69 teams and the week it was scored in, I can then use this data in my Power BI report to provide the top 3 scoreboard including the week where the score was achieved.
I maintain an Excel file which is used by Power BI to provide weekly status of a Fantasy Football (Soccer) league operating at my place of work. There is one tab in the Excel that has 4 columns, the first is the game week number which repeats the same value 69 times from 1 to 38, the second is is the ID number for each team 1-69 so for each game week all teams have a row, the third column is the total points per team (manually updated once a week) and the fourth column is the points scored in the most recent week (formula taking previous week score from current).
In Power BI we are able to report the 3 highest ever weekly scores, however when trying to show in which week the score was achieved my filtering for top 3 stops working.
I would like to create a separate tab in my Excel which will show the maximum points scored for each of the 69 teams and the week it was scored in, I can then use this data in my Power BI report to provide the top 3 scoreboard including the week where the score was achieved.