The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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