cancel
Showing results for
Did you mean:
Frequent Visitor

## Error counting weekends

Hi guys.

I have 2 tables. One is the DimDate table where I have the Non-working days column, Saturdays and Sundays (0 Weekly, 1 Non-working). The other GTI Table where there are 2 columns with 2 dates: Creation date and expiration date. Both tables are linked.

In the GTI table, I'm calculating how many Saturdays and Sundays there are between Creation date and expiration date:

FDS = CALCULATE (SUM (DimDate [DiaLaboral]); FILTER (DimDate; DimDate [Date]> = FIRSTDATE (GTI_POWERBI [Creation Date]) && DimDate [Date] <LASTDATE (GTI_POWERBI [End Date]))).

This works very well for me but when the Due Date is a Monday, the previous weekend does not count it (Case 1 in Red) but I have another date if it does (Case 2 in blue).

In the image, the result of case 1 must be 10 and not 8. But case 2 is correct and both end on a Monday.

Can you help me?

Case 1: It´s wrong

Case 2: Its Ok

I appreciate your help.  Sorry for my English

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: Error counting weekends

@jbolivar

Hi, you can use a calculated column with:

```FDS =
CALCULATE (
SUM ( DimDate[DiaLaboral] ),
FILTER (
DimDate,
DimDate[Date] >= GTI_POWERBI[Fecha de Creación]
&& DimDate[Date] < GTI_POWERBI[Fecha de Vencimiento]
)
)```

Regards

Victor

Lima - Peru

Lima - Peru

Proud to be a Datanaut!

2 REPLIES 2
Highlighted
Super User

## Re: Error counting weekends

@jbolivar

Hi, you can use a calculated column with:

```FDS =
CALCULATE (
SUM ( DimDate[DiaLaboral] ),
FILTER (
DimDate,
DimDate[Date] >= GTI_POWERBI[Fecha de Creación]
&& DimDate[Date] < GTI_POWERBI[Fecha de Vencimiento]
)
)```

Regards

Victor

Lima - Peru

Lima - Peru

Proud to be a Datanaut!

Frequent Visitor

## Re: Error counting weekends

Excelente Vvelarde.

Muchas gracias. Funcionó perfecto