Forum Discussion

jbolivar's avatar
jbolivar
Frequent Visitor
8 years ago
Solved

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 dat...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    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

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

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

jbolivar's avatar
jbolivar
Frequent Visitor
8 years ago

Excelente Vvelarde.

 

Muchas gracias. Funcionó perfecto