topic Re: (latest date - transaction date) - non working days in DAX Commands and Tips

(latest date - transaction date) - non working days

Easley06 — Mon, 22 Aug 2022 13:38:17 GMT

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.

Re: (latest date - transaction date) - non working days

johnt75 — Mon, 22 Aug 2022 14:28:36 GMT

You can try

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

Re: (latest date - transaction date) - non working days

v-zhangti — Thu, 25 Aug 2022 08:59:35 GMT

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.