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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

If the date is in the same table

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

 

Also please refer this pbix

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

 

It has datediff, within table across table

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin