topic Re: Compare a function with a date. Help me please. (DAX) in DAX Commands and Tips

Compare a function with a date. Help me please. (DAX)

Anonymous — Tue, 17 Mar 2020 15:02:11 GMT

Can someone help me? I inserted the following function:

if [Status] = "in progress" and [Actual End] = null and [Scheduled End]> = Date.IsInCurrentDay then "3" else
if [Real Start] = null and [Programmed End]> = Date.IsInCurrentDay then "1" else
if [Actual End] <= Date.IsInCurrentDay and [Actual End] <= [Scheduled End] and [Actual End] <> null then "1" else "2"

I get the following message: Expression.Error: We were unable to apply the <operator to the Function and Date types.
Details:
     Operator = <
     Left = [Function]
     Right = 08/29/2019

Can someone help me?

Re: Compare a function with a date. Help me please. (DAX)

Greg_Deckler — Tue, 17 Mar 2020 15:16:23 GMT

Maybe it is just how you posted it bu there were spaces between some of the >= so I removed those below. Hard to test though.

if [Status] = "in progress" and [Actual End] = null and [Scheduled End] >= Date.IsInCurrentDay then "3" else
if [Real Start] = null and [Programmed End] >= Date.IsInCurrentDay then "1" else
if [Actual End] <= Date.IsInCurrentDay and [Actual End] <= [Scheduled End] and [Actual End] <> null then "1" else "2"

Re: Compare a function with a date. Help me please. (DAX)

Anonymous — Tue, 17 Mar 2020 16:35:57 GMT

Greg, first of all thank you for your interest in helping, but it has nothing to do with space. "No syntax errors detected". The "x" of the question here is how to compare a column with dates to a function. In the example case I am trying to use the "Date.IsInCurrentDay" function.

Re: Compare a function with a date. Help me please. (DAX)

Anonymous — Tue, 17 Mar 2020 16:40:24 GMT

To make it clearer, I want to compare a column with dates and a function with a current date to find out if this condition sets a status to "Expired", for example.

Re: Compare a function with a date. Help me please. (DAX)

Anonymous — Sun, 22 Mar 2020 13:48:40 GMT

Well, the syntax for the function is:

Date.IsInCurrentDay(dateTime as any) as nullable logical

What you're trying to do is use the function without arguments, which is akin to referring to the function and not its results.

What you probably need is a comparison with:

DateTime.FixedLocalNow()

Best
D