Forum Discussion
third_hicana
Helper IV
Helper IVIf blank return a "text"
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 Lis...
Please try
Resource Status =
IF (
COALESCE ( 'Resource List'[End Date], TODAY () ) < TODAY (),
"Contract End",
"Ongoing"
)
third_hicanaHelper IV
Helper IVHi 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
Community Champion
Community ChampionPlease 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. 🙂