Calculating Days Between a Date and Today

Power BI
1

I have a database with some project numbers and the start date of the projects. I have the date table link to that database.

  1. I need a DAX formula that will calculate how many days from today’s date the projects have been open (start date), using the date table excluding weekends (and holidays in Canada if possible).

I am trying that formula but it does not work
WorkingDays =
CALCULATE(
SUM(Dates[Week Number]),
FILTER(
ALL(Dates),
Dates[Date] = MIN(Start date])
&& Dates[Date] <= TODAY()))

  1. To complicate matters. Is it possible to have another DAX formula that can highlight “Fail” for all projects that are over 60 days (Start date and today’s date), excluding weekends

Is it possible, thanks in advance

2

Have tried DateDiff? DATEDIFF ( StartDate, EndDate, DAY )

If you need to exclude weekends, try something like this -

1 Like
3

Hello @Alourdes

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark his answer as the SOLUTION.

Thank you

4

Bumping this post for more visibility from our experts and users.

5

Hi @Alourdes

Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.

We hope you’ll give your insights on how we can further improve the Support forum. Thanks!