Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
=
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 )
)).
Solved! Go to 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
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
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 )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
70 | |
69 | |
23 | |
18 | |
13 |