Facing error in DAX formula

[dharmdutt]

Facing error in DAX formula

=

VAR Start_Date =

MIN ( data[Start] )

VAR End_Date =

MAX ( data[End] )

VAR Column_Date =

MAX ( 'Calendar'[Date] )

RETURN

IF ( Start_Date <= Column_Date && End_Date >= Column_Date, 1, BLANK )

i get error:

The expression is not valid or appears to be incomplete. Please review and correct the expression.
The syntax for ')' is incorrect. (DAX(

VAR Start_Date = MIN ( data[Start] )

VAR End_Date = MAX ( data[End] )

VAR Column_Date = MAX ( 'Calendar'[Date] )

RETURN

IF ( Start_Date <= Column_Date && End_Date >= Column_Date, 1, BLANK )
)).

[Anonymous · Accepted solution]

Hi @dharmdutt ,

That may be where the problem lies.

You need to add () to BLANK for the engine to recognize it as a function.

Measure = 
VAR Start_Date =
MIN ( data[Start] )
VAR End_Date =
MAX ( data[End] )
VAR Column_Date =
MAX ( 'Calendar'[Date] )
RETURN
IF ( Start_Date <= Column_Date && End_Date >= Column_Date, 1, BLANK() )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[lbendlin]

The formula is syntactically ok but you are missing the name of the item

a =
VAR Start_Date =
    MIN ( data[Start] )
VAR End_Date =
    MAX ( data[End] )
VAR Column_Date =
    MAX ( 'Calendar'[Date] )
RETURN
    IF ( Start_Date <= Column_Date && End_Date >= Column_Date, 1 )