Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hello @parry2k
I added a simple example of what I want to a new sheet. Hope this helps.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
87 | |
84 | |
69 | |
69 |
User | Count |
---|---|
227 | |
127 | |
118 | |
82 | |
80 |