Forum Discussion

third_hicana's avatar
third_hicana
Icon for Helper IV rankHelper IV
4 years ago
Solved

If 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...
DAX Commands
Help Request
logic
Show and Tell
Tutorial Requests
  • tamerj1's avatar
    tamerj1
    4 years ago

    third_hicana 

    Please try

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi third_hicana 

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

third_hicana's avatar
third_hicana
Icon for Helper IV rankHelper IV
4 years ago

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's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    third_hicana 

    Please try

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

    • third_hicana's avatar
      third_hicana
      Icon for Helper IV rankHelper IV
      4 years ago

      Hi tamerj1 

      It works now. Thank you very much. 🙂