We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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.
Solved! Go to 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.
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.
You can try
Num working days =
NETWORKDAYS (
SELECTEDVALUE ( 'Table'[transaction date] ),
TODAY (),
1,
CALCULATETABLE ( VALUES ( 'Date'[Date] ), 'Date'[non_working_day] = 1 )
)
User | Count |
---|---|
12 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
24 | |
21 | |
11 | |
9 | |
6 |