Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |