Forum Discussion
SQL to DAX Converstion - Create complex aggregation measure using conditions
I'm new to PowerBi/DAX and have a burning need to create ~10-15 complex aggregate measures from a related table (Deal Investment) that will be aggregated and stored on another table (Deal). The diff...
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks Greg, point taken! Since my question is really a question of syntax conversion from SQL to DAX for nested Case/When statements, I assumed that providing the relevant table references and SQL logic would suffice. That being said, I will provide a dataset and walk through the calculation logic in plain English. Thanks for taking the time to respond!
