Converting PeopleSoft Query into DAX/Power BI

Hi Folks,

I need help in solving following issue.

I want to convert following PeopleSoft Query into Power BI.  

Note: PeopleSoft is being replaced by Power BI, data will be in Oracle 11 and we have Direct Query connection.

 ---- 

Select A.Field1,Field2,B.Field3Field4,C.Field5

FROM TABLE1 A, Table2 B, Table3 C

WHERE A.FIELID = B.FIELDID

   AND C.DATE1 =

       (SELECT MAX(C_ED.DATE1) FROM Table3 C_ED

       WHERE C.CODE = C_ED.CODE

       AND C_ED.DATE1 <= SYSDATE)

   AND C.CODE = A.CODE

   AND A.FIELDID ="FIELDID Entered in slicer"

  AND A.DATE2 > "DATE entered in filter"

This query is supposed to display a Table by selecting fields from 3 DB Tables, based on 2 entries FIELDID and "any DATE" --  plus following logic   

To explain the logic -->I have three tables Table1, Table2 and Table3

Table1 and Table2 has FIELDID and CODE columns, which are also creating relation between the tables.

All 3 tables have different dates of transactions.

I need to select a DATE from Table1, with following criteria:

Matching FIELDID from Table1 and Table2

For Max Date in Table C, where Code in table A = Code in Table B

and Date in Table C <= CURRENTDATE

and CODE in Table C = Code in Table A

Plus I also need to know what does ED. represents in C_ED.CODE or C_ED.DATE1

Appreciate help here