SQL to DAX

Question

Hi Team,&nbsp;Can anyone help me to convert below SQL into DAX&nbsp;&nbsp;CASE&nbsp;WHEN DIM_PO.DELIV_PERFM_GR_DT &lt;= DIM_PO.EKES_MIN_POA_DT+1&nbsp;&nbsp;AND&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(DIM_PO.DELIV_PERFM_GR_QTY = DIM_PO.PO_QTY OR DIM_PO.DELIV_COMPLETED_IND='X')&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; THEN 'Yes'WHEN DIM_PO.DELIV_PERFM_GR_DT &gt; DIM_PO.EKES_MIN_POA_DT+1&nbsp;AND&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(DIM_PO.DELIV_PERFM_GR_QTY = DIM_PO.PO_QTY OR DIM_PO.DELIV_COMPLETED_IND='X')&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; THEN 'No'&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;ELSE 'Check'

anonymous · Answer

if(Table[DELIV_PERFM_GR_DT] &lt;= Table[EKES_MIN_POA_DT]+1&nbsp;&nbsp;AND&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(Table[DELIV_PERFM_GR_QTY] = Table[PO_QTY] OR Table[DELIV_COMPLETED_IND]='X'),"Yes",if(Table[DELIV_PERFM_GR_DT] &gt; Table[EKES_MIN_POA_DT]+1&nbsp;AND&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(Table[DELIV_PERFM_GR_QTY] = Table[PO_QTY] ORTable[DELIV_COMPLETED_IND]='X'),"No","Check"))&nbsp;Thanks &amp; regards,Pravin Wattamwarwww.linkedin.com/in/pravin-p-wattamwarIf I resolve your problem Mark it as a solution and give kudos.check my blog herehttps://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/913784&nbsp;&nbsp;

anonymous · Answer

Hi,&nbsp;We cant directly add the table name in IF condition&nbsp;Can you help me to get the desired output

Forum Discussion

SQL to DAX

2 Replies

Related content

Convert SQL into DAX

DAX equivalent of SQL's NOT IN?

DAX equivalent of SQL LIKE

Converting SQL into DAX...

SQL TO DAX