Forum Discussion
SQL to DAX conversion
Hi all I've got quite a heavy SQL query and need help on getting the DAX equivalent. Any responses would be appreciated: select sum(lost_sales) as lost_sales, event from (select event, creat...
Can you give us some sense of your data (sample data) and expected output? Also, purpose would be good, I'm not entirely sure if what you really need is DAX or M or just paste this SQL code into your query.
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