Need Help with this DAX query

[Anonymous]

I have written this query in power query on a Direct query table  sources to create a new  custom column. However my syntax is complaining about a missing token and i cant quit get what the issue is. can you any be kind enough help me with the syntaxt here?

if(
( NOT ( ISBLANK ([ACT_START_DATE] ) ) and ISBLANK ([ACT_END_DATE] ) )
or [ACT_START_DATE]
<= TODAY () + 2,
[FINISH_DATE] - 1
)

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

So can you try my first method, create columns in Power BI Desktop with DAX, I try it is okay.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

HI, @Anonymous ;

You could modfiy the column by dax .

COLUMN =
IF (
    (
        [ACT_START_DATE] <> BLANK ()
            && [ACT_END_DATE] <> BLANK ()
    )
        || [ACT_START_DATE]
            <= TODAY () + 2,
    [FINISH_DATE] - 1
)

Or in power quey by M ;

custom=if ([ACT_START_DATE] <> null and [ACT_START_DATE]<> null)  
or [ACT_START_DATE]<= DateTime.LocalNow() 
then Date.AddDays([FINISH_DATE],-1) else null

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I get this error message - it wants me to switch to import modebut my requirements is to use direct query. do you know if there is a workaround?