Forum Discussion
SQL to Dax (convert)
Hello Experts, I have a sql command but I need to have dax formula. The problem i don't know how to convert this formula in a Dax formula. sum(case when tr1.SDATEOCCURRED ...
v-lili6-msft
Community Support
Community Supporthi RMD
What is the relationship among these thress tables? and do you want to create a measure or a calculate table?
and you may use SUMX Function in the formula
https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi
and sample data and expected output would help tremendously.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lin