Need support on DAX SUBquery for multiple tables

Question

0

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 as a newbie to Power BI, 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

    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 '%Field update Sender:%'
 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 '%Field update Sender:%'
               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