Power BI DAX subquery for multiple Tables - Complex DAX need help

[ramshoney1225]

Hi,

I have 3 tables which I have mentioned in the below SQL Query, which I need to convert into a DAX formula which I'm not able to do , which similarly I need to do the same for almost 5 - 6 columns.

If this has figured out, I can do the remaining 5 DAX Calculated columns, which I need support on writing Complex DAX for below SQL need to conver DAX calc / measure formula

(
SELECT Substr(tablea.text_noted,0,500)
FROM   sys_data_node_tab TableA,
       sys_data_noted TableC
WHERE  tablea.id_name = tablec.id_name
AND    tablea.task_note_text LIKE '%Sender Info Update%'
AND    tablea.task_note_entered_date =
       (
              SELECT Max(tableb.task_note_entered_date)
              FROM   sys_data_node_tab TableB,
                     sys_data_noted TableC
              WHERE  tableb.task_note_text LIKE '%Sender Info Update%'
              AND    tableb.id_name = tablec.id_name )
AND    rownum = 1
)
 as text_noted;

Please support on this or help me guidance in writing this Complex DAX.

Thanks

[parry2k]

@ramshoney1225 you don't need to provide full/real data, just create something dummy that is relevant and the expected output.

[parry2k]

@ramshoney1225 it will be easier if you post sample data and the expected output.

✨ Follow us on LinkedIn and  to our YouTube channel

[ramshoney1225]

Hi @parry2k 

ya but i'm unable to get the data outside and the tables have huge columns as wel.

just help me on some overview in writing, so that i can create that DAX 

Thanks,