cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II

## (latest date - transaction date) - non working days

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.

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

You can try

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

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors