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. 
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Try

Target End Date =
SELECTEDVALUE ( 'Support Request'[EndDate], EDATE ( TODAY (), 2 ) )
howcreech's avatar
howcreech
Regular Visitor
1 year ago

Hi johnt75,

that removed the blank items from the report instead of filling in a date 2 months from today. Sorry if my question is not complete, I am still working as a new user of Power BI and struggle with many of the topics.