(latest date - transaction date) - non working days

[Easley06]

Hi,

would like to ask for possible solution for this 

i have column for today and transaction date i want also to exclude weekend/holiday 

based on this columns

Measure = Total count of records 
((ABS(current date - date_reported)) - nonworking days)

Thanks.

[v-zhangti · Accepted solution]

Hi, @Easley06 

You can try the following methods.

Measure = 
VAR N1 =
    ABS ( [Today] - SELECTEDVALUE ( 'Table'[transaction date] ) )
VAR N2 =
    CALCULATE (
        COUNT ( 'Date'[Non working day] ),
        FILTER (
            ALL ( 'Date' ),
            [Date] >= SELECTEDVALUE ( 'Table'[transaction date] )
                && [Date] <= [Today]
                && [Non working day] = 1
        )
    )
RETURN
    N1 - N2

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[johnt75]

You can try

Num working days =
NETWORKDAYS (
    SELECTEDVALUE ( 'Table'[transaction date] ),
    TODAY (),
    1,
    CALCULATETABLE ( VALUES ( 'Date'[Date] ), 'Date'[non_working_day] = 1 )
)