Forum Discussion

Smiller100's avatar
Smiller100
New Member
4 years ago
Solved

DATEADD returning all blank values

Hello everyone, new Power BI user here.   I am attempting to create an expected date column in a table based off an initial "Join Date" and an ending "Go-Live" date, with the expected ending date f...
Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    Hi Smiller100 ,

     

    I think simply writing 

    Column2 = 'Go-Live Dates'[Join Date]+'Go-Live Dates'[Column] 
    will do it:

     

    Jori 
     
    If I answered your question, please mark it as a solution to help other members find it more quickly.
parry2k's avatar
parry2k
Super User
4 years ago

Smiller100 I think you want to use DATEDIFF not DATEADD

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Smiller100's avatar
Smiller100
New Member
4 years ago

parry2k thank you for the suggestion, unfortunately for this analysis I think I do want to be using DATEADD instead of DATEDIFF because I am trying to determine the expected date based off of an initial date and an average for number of days it typically takes for a record to "go-live." If there is a way to accomplish this with DATEDIFF instead of DATEADD then could you shed some light on how I would accomplish this?