Forum Discussion
Compare a function with a date. Help me please. (DAX)
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 [P...
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.
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
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