If blank return a "text"

[third_hicana]

 Hi DAX Experts. Do you know what is wrong with my Dax formula. So here's the logical test.

1. If Resource List end date is today and prior,then it will return as "Contract End".

2. If Resource List end date is not today but on a later date and beyond, then return a text as "Ongoing"

3. If Resource List end date is blank, then return a text as also "Ongoing".

My error is if resource list end date is blank the return text is "Contract End" which is supposed to be "Ongoing".

Thank you for your help. 😞

[tamerj1]

Hi @third_hicana 

can you please compy/paste the formula so I can edit?

[third_hicana]

Hi @tamerj1  Here it is. Thank you.

Resource Status = IF('Resource List'[End Date] < TODAY(),

"Contract End",

IF('Resource List'[End Date] >= TODAY(),

"Ongoing", "Ongoing"))

[tamerj1 · Accepted solution]

@third_hicana 

Please try

Resource Status =
IF (
COALESCE ( 'Resource List'[End Date], TODAY () ) < TODAY (),
"Contract End",
"Ongoing"
)

[third_hicana]

Hi @tamerj1 

It works now. Thank you very much. 🙂