Forum Discussion
Facing error in DAX formula
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 )
)).
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 TeamIf 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
2 Replies
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 )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 TeamIf 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
