Forum Discussion

topazz11's avatar
topazz11
Icon for Helper III rankHelper III
6 years ago
Solved

Days difference between two dates

I have seen a number of posts about calculating the day count between two date.  None seem to address my specific use case. I'm stuck with some calculation and I could use some help.    This does...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , topazz11 

    As mentioned  by  MattAllington   amitchandak 
    Create calculate column :

     

    Date Dif = VALUE(A[Finish]) - VALUE(A[Goal Date])

     

    Or create measure :

     

    Date Dif2 = DATEDIFF(MAX(A[Goal Date]),MAX(A[Finish]),DAY)

     

    It shows as below:

     

    Here  is a  demo .

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
6 years ago

I think it doesn't need to be that complex. Assuming you are writing a column, try this. 

Date Dif = value(A[Finish] - A[Goal Date])

 
PS. Don't call your table A