If date is less than or equal to

DAX DAX Calculations
1

If the date is less than or equal to today, make the date today. I get this error:

Expression.Error: We cannot apply operator < to types Function and Date.
Details:
    Operator=<
    Left=[Function]
    Right=1/22/2019

image
image875×475 21.2 KB

2

Hi @Usates,

Try using DateTime.LocalNow(), be aware with the function with date and time and only date.
Also, if you have null values, you need to start comparing it.

3

Same error. Thanks for your help.

image
image870×462 20.5 KB

4

@Usates,

How is your date ?
Date and time or only date ? If only date, try Date.From(DateTime.LocalNow())

2 Likes
5

Works. THANK YOU!!