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

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