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. 
v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

Hi howcreech 

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and give a kudos, as this helps other members in  community.

Thank You!