Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Please help me I have this date column and I want to make a measure;
IF [date] < now THEN urgent ELSE not urgent
I tried to make a new measure with:
IF = NOW()>FIRSTNONBLANK(Sheet1[Date],Sheet1[Date]),"urgent","not urgent"))
But it still returns The syntax for ",' is incorrect
Pls help, thanks!
Solved! Go to Solution.
The syntax of you measure as mentioned in this post is completely wrong. So you may have misspelled that in the post.
Something like this would pass the syntax test. But I'm not sure if it gives you the expected result.
Measure Name = IF ( NOW () > FIRSTNONBLANK ( Sheet1[Date], Sheet1[Date] ), "urgent", "not urgent" )
The syntax of you measure as mentioned in this post is completely wrong. So you may have misspelled that in the post.
Something like this would pass the syntax test. But I'm not sure if it gives you the expected result.
Measure Name = IF ( NOW () > FIRSTNONBLANK ( Sheet1[Date], Sheet1[Date] ), "urgent", "not urgent" )
Ah yes! Sorry my bad
This works perfectly, thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |