Forum Discussion

Coelijoeli's avatar
Coelijoeli
Advocate I
10 years ago

Days between two dates columns

Hello community,   I'm building a dashboard with Power BI Desktop. I've connected a SQL server database which has two date fields:   [Transactiondate] [Closed]   What I want to do is get the ...
Need Help
HarrisMalik's avatar
HarrisMalik
Continued Contributor
10 years ago

gkhare there is a mistake in your formula the third argument to DATEDIFF is Interval not function. Use following formula:

 

DaysLenght = DATEDIFF(AA_SALES_FACT[CLOSE_DATE],AA_SALES_FACT[START_DATE],DAY)

 

Edit: I do not know your data model just to be sure the first argument of DATEDIFF() is Start Date, second is End date and third is interval i.e. DAY, MONTH,YEAR etc

 

DATEDIFF(<start_date>, <end_date>, <interval>)

 

WendyMc's avatar
WendyMc
New Member
10 years ago

Thanks for posting - just what I was looking for

  • peymanrmt's avatar
    peymanrmt
    New Member
    8 years ago

    Hi all,

     

    How do we calculate the time interval in hours between two dates while excluding the weekends and US holidays in the calendar? Any help is much appreciated.

  • peymanrmt's avatar
    peymanrmt
    New Member
    8 years ago

     Hi all,

     

    How do we calculate the interval between two dates, while excluding the weekends and US holidays. We need this interval to be calculated only for business days, excluding weekends and holidays to have a good measure of performance. Any help is much appreciated. BTW, the interval should be calculated in hours, NOT days or months.

    Any help is much appreciated.