Forum Discussion

howcreech's avatar
howcreech
Regular Visitor
1 year ago
Solved

Date Measure if blank

Hi,   What I want to create is a measure that looks for a date in a named column, if it is blank to run edate(today(),2) if it contains a date return the existing date. I used a similar measure on ...
  • howcreech's avatar
    howcreech
    1 year ago

    Hi Everyone,

    I used some of the information provided and used an internal AI system to find the below DAX operation that worked:

     

    Target End Date 2 =
    IF(
        not(isblank(selectedvalue('Support Request'[Completed]))),
        selectedvalue('Support Request'[Completed]),
        edate(today(),2))
     
    Thank you everyone for the help. 
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi howcreech ,
You can try the following code

Target End Date = 
IF(
    ISBLANK(SUM('Support Request'[EndDate])),
    EDATE(TODAY(), 2),
    SUM('Support Request'[EndDate])
)

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

howcreech's avatar
howcreech
Regular Visitor
1 year ago

Hi Albert He,

I tried your solution, but it didn't work either. However, I have tried a combination or yours and johnt75 to get a partial result. What I am struggling with now is that the formula is overwriting the data that exists in some instances. Below is the formula I input:

Target End Date =
IF(
    isblank(selectedvalue('Support Request'[EndDate])),
    EDATE(TODAY(),2),
    selectedvalue('Support Request'[EndDate]))
 
I'm not sure what is happening to the list data, but I know the EndDate was the previous name the column had (it currently has the name Target End Date). With this formula I'm hoping to leave the date if it currently exists, if not run the edate formula to add on two months.