Forum Discussion
Solved
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_D...
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
lbendlin
Super User
Super UserThe 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 )