topic Re: If blank return a "text" in DAX Commands and Tips

If blank return a "text"

third_hicana — Sat, 17 Sep 2022 03:08:08 GMT

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 — Sat, 17 Sep 2022 04:03:48 GMT

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

third_hicana — Sat, 17 Sep 2022 04:07:56 GMT

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 — Sat, 17 Sep 2022 04:13:07 GMT

Please try

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

third_hicana — Sat, 17 Sep 2022 04:16:32 GMT

Hi tamerj1

It works now. Thank you very much. 🙂