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...
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!
