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.

     

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
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.