Forum Discussion

third_hicana's avatar
third_hicana
Helper IV
3 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 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. 😞

 

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"
    )

4 Replies

    • third_hicana's avatar
      third_hicana
      Helper 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
        Community Champion
        3 years ago

        third_hicana 

        Please try

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