-
Notifications
You must be signed in to change notification settings - Fork 2
/
02-Azure-SQL-Dax-Networkdays-Function.msdax
60 lines (50 loc) · 1.17 KB
/
02-Azure-SQL-Dax-Networkdays-Function.msdax
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
/* 1. Função Networkdays
NETWORKDAYS ( <start_date>, <end_date> [, <weekend>] [, <holidays>] )
1 or omitted: Saturday, Sunday;
2: Sunday, Monday;
3: Monday, Tuesday;
4: Tuesday, Wednesday;
5; Wednesday, Thursday;
6: Thursday, Friday;
7: Friday, Saturday;
11: Sunday only;
12: Monday only;
13: Tuesday only;
14: Wednesday only;
15: Thursday only;
16: Friday only;
17: Saturday only.
*/
EVALUATE
ROW(
"Tipo", "Sab/Dom",
"Dias Úteis", NETWORKDAYS(dt"2022-09-01",dt"2022-09-30")
)
/* Consulta Resultado Final */
EVALUATE
UNION (
ROW (
"Tipo", "Sab/Dom",
"Dias Úteis", NETWORKDAYS (
dt"2022-09-01",
dt"2022-09-30"
)
),
ROW (
"Tipo", "Domingo",
"Dias Úteis", NETWORKDAYS (
dt"2022-09-01",
dt"2022-09-30",
11 -- Ignorar Domingo
)
),
ROW (
"Tipo", "Sab/Dom + 7 Setembro",
"Dias Úteis", NETWORKDAYS (
dt"2022-09-01",
dt"2022-09-30",
1, -- Ignorar Sábado e Domingo
{ dt"2022-09-07" } -- Ignorar Feriado 7 Setembro
)
)
)