How can i rewrite the below query in DAX

[Anonymous]

I am trying to re write this query from POWER query using DAX and i cant figure out the syntax. can anyone point me in the right direction?

= Table.AddColumn(Source, "Custom", each if((Date.From([ACT_START_DATE]) <>"" ) and (Date.From([ACT_END_DATE]) = "") or
(Date.From([START_DATE]) <= Date.AddDays(Date.From(DateTime.LocalNow()),2))) then (Date.From(Date.AddDays([FINISH_DATE],-1))) else null)

[johnt75 · Accepted solution]

try

New column =
IF (
    ( NOT ( ISBLANK ( 'Table'[start date] ) ) && ISBLANK ( 'Table'[End date] ) )
        || 'Table'[start date]
            <= TODAY () + 2,
    'Table'[End date] - 1
)