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
    3 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
3 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
    3 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
      3 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
        3 years ago

        Hi tamerj1 

        It works now. Thank you very much. 🙂