Calculated table with maximization

[konstant]

Hello everyone!

I have a table with stock returns for a given date, ticker and a combination of parameters X, Y, Z. I would like to find which parameters X, Y and Z maximize the sum of stock returns for each ticker and each month. My sample data is here.

I guess I need to create a calculated table with the following columns: 

ticker | month | X | Y | Z | sum of returns | N,

which contains only XYZ that give the maximum of sum of returns and where N is a number trades for a given XYZ. 

Any help with DAX would be highly appreciated.

[parry2k]

@konstant Wow, do you want me to decode CSV file first? If you really need help, give neat and clean data with the expected output. 

[parry2k]

@konstant thanks for sharing the data, can you put the example output on the 2nd sheet with the explanation? It will help to provide a relative solution.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

[konstant]

Hello @parry2k 

I added a simple example of what I want to a new sheet. Hope this helps.