Forum Discussion

TMO_KY's avatar
TMO_KY
Helper II
6 years ago
Solved

Calculate dates between 2 dates but exclude Start / End date

I have an interesting ask, I have a code that I use to find dates between 2 given dates;  = Table.AddColumn(#"Renamed Columns", "Work Days", each { Number.From([First Date])..Number.From([Last Date...
DAX Calculation
Tip & Tricks
Tips and Tricks
  • arq52's avatar
    arq52
    6 years ago

    Hello,

    use Date.AddDays ;

    Table.AddColumn(#"Renamed Columns", "Work Days", each { Number.From(Date.AddDays([First Date],1))..Number.From(Date.AddDays([Last Date],-1)) })

    Best regards

arq52's avatar
arq52
Frequent Visitor
6 years ago

Hello,

use Date.AddDays ;

Table.AddColumn(#"Renamed Columns", "Work Days", each { Number.From(Date.AddDays([First Date],1))..Number.From(Date.AddDays([Last Date],-1)) })

Best regards

  • TMO_KY's avatar
    TMO_KY
    Helper II
    6 years ago

    arq52  Much appreciated!  Now I have less steps in my query.  🙂