Problems with the difference of days between dates with times

[Syndicate_Admin]

Dear community, I have a small problem that I have not been able to solve.

I have a dataset that contains a creation date column (date where a request is generated) and a resolution date (date where a request is resolved), both columns contain the corresponding date and time. The problem is that I need to create a new column that gives me the difference in working days (Monday to Friday) and also does not consider non-working days or holidays.

An important point to consider is that the difference in days should be kept in decilames.

As an example:

In row 5, 6 and 7 the working days discount Saturday and Sunday. And in row 8 and 9 it is discounted on Friday (since it is non-work or holiday), Saturday and Sunday.

I would be interested in generating this column both in Power Query and with DAX formulas, but retaining the decimals since it is relevant to keep the data of the time when the requests are generated.

[v-luwang-msft]

Hi @Syndicate_Admin ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Syndicate_Admin ,

You can refer to the following article, which describes how to calculate the working days excluding weekends.

refer:

https://community.powerbi.com/t5/Desktop/Difference-between-dates-considering-only-working-days/td-p...

Best Regards

Lucien