Forum Discussion

lmarins's avatar
lmarins
Frequent Visitor
4 years ago
Solved

Column count working days (without weekend/holidays) between two dates columns in the same table

Hello! I need to create a new column in a table in Power BI that contains the count of business days (excluding weekends and holidays) between two date columns in the same table. I tried with the D...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I tried to create a sample pbix file like below.

    It is for creating a new column, and it only counts days without weekends.
    In my opinion, if you want to exclude your public holiday, having a dim-calendar table can help.

     

     

    Diff count without weekend CC =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            GENERATESERIES ( Data[StartDate], Data[EndDate] ),
            "@weekday", WEEKDAY ( [Value], 2 )
        ),
        NOT ( [@weekday] IN { 6, 7 } )
    )
)
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi lmarins ,

Does your problem be resolved? Do you need more further help?

Here's a blog about Using-DAX-to-create-a-calendar-table-with-holidays

If your problem has been resolved, please kindly accept the helpful replies as solutions. If not, please feel free to let me know your difficulties.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.