Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello, I have created a measure to know the days that have passed from a date until today, so far so good.
My problem is that I want to put a conditional on it and I can't, I'll give you my measurement:
Day =
Solved! Go to Solution.
@Aguirre in case this solves your question, please mark this as solution. Appreciate your Kudos:
Day =
var startDate=MIN(F_contract[F.Send])
var endDate=TODAY()
var _result = DATEDIFF(startDate,endDate,DAY)+0
RETURN
IF(
ISBLANK(SELECTEDVALUE(F_Contract[F.signed])) && _result > 8,
_result,
"ok"
)
@Aguirre just to make sure, you tries this and it didn't work:
Day =
var startDate=MIN(F_contract[F.Send])
var endDate=TODAY()
var _result = DATEDIFF(startDate,endDate,DAY)+0
RETURN
IF(ISBLANK(SELECTEDVALUE(F_Contract[F.signed])),_result, "ok")
well, excuse me.
I need it to show me only the days, when the value is fulfilled is F_Contract[F.signed]= Null and "_result" >8 days.
Something like that:
YES::
F_Contract[F.signed] && _result >8
Show the day else show OK
@Aguirre in case this solves your question, please mark this as solution. Appreciate your Kudos:
Day =
var startDate=MIN(F_contract[F.Send])
var endDate=TODAY()
var _result = DATEDIFF(startDate,endDate,DAY)+0
RETURN
IF(
ISBLANK(SELECTEDVALUE(F_Contract[F.signed])) && _result > 8,
_result,
"ok"
)
Perfect, it's what I needed, thank you very much.
The solution is perfect, but I am missing a detail, I want the result of the _result to be > 8 days and the Null condition is also met.
I have tried but it does not give me correct, can you help me
Not sure I understand. Can you write in simple words what are the conditions that you want to be for what result. All the options
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
12 | |
11 | |
10 | |
9 |