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.
MATTHEWW's avatar
MATTHEWW
Frequent Visitor
3 years ago

Use EDATE() function instead, DATEADD() can only return the dates that exist in the dates column.

bouchspc's avatar
bouchspc
Regular Visitor
2 years ago

Very nice!  Struggled with DATEADD() not working with TODAY() but EDATE() worked great.  Thanks!!