Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help with this DAX query

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....
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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?