SQL to Dax (convert)

Question

Hello Experts,&nbsp;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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum(case when tr1.SDATEOCCURRED &lt;= tr.sdateoccurred&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; then isnull(dt.samount, 0)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + isnull(dt_vat.samount, 0)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end) on_time_amount&nbsp;I have the following tables in Powerbi: TRANS, TRANS (1) and DetailIn the sql report I have the folloing tables: tr1 = Trans (1), Tr = Trans and dt=Detail.&nbsp;many thanks in advance for your help!!!&nbsp;

parry2k · Answer

RMD&nbsp;please paste the sample data with the expected output.&nbsp;Read this post to get your answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

v-lili6-msft · Answer

hi&nbsp;&nbsp;RMD&nbsp;
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
&nbsp;
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
&nbsp;
Regards,
Lin

Forum Discussion

SQL to Dax (convert)

2 Replies

Related content

Convert SQL into DAX

Converting SQL into DAX...

Convert SQL To DAX

convert sql joins to dax

Convert SQL to DAX