Spreadsheet: 678010d1589657470-dax-measure-days-lost-to-absence-absence-reports_example-bfaws-
Sheet: Raw Data

ResID | ResID(T) | Costc(T) | Grade(T) | Date | Abs. code(T) | Hours | Days
10201 | Samatha Jones | Procurement | Level 3 | 2018-01-05 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-01-12 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-02-01 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-02-08 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-02-14 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-02-15 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-02-21 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-02-23 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-02-27 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-03-02 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-04-04 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-04-13 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-06-07 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-06-08 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-06-20 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-07-10 00:00:00 | Annual Leave | 3.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-07-20 00:00:00 | Annual Leave | 5
11715 | [NAME] | Finance | Level 4 | 2018-07-23 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-07-24 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-07-25 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-07-26 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-07-27 00:00:00 | Annual Leave | 5
11715 | [NAME] | Finance | Level 4 | 2018-07-27 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-07-30 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-07-31 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-08-01 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-08-02 00:00:00 | Annual Leave | 7.5
11715 | [NAME] | Finance | Level 4 | 2018-08-03 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-07 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-08 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-09 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-10 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-14 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-15 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-16 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-17 00:00:00 | Annual Leave | 5
10201 | Samatha Jones | Procurement | Level 3 | 2018-08-21 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-09-04 00:00:00 | Annual Leave | 7.5
11901 | [NAME] | Human Resources | Level 4 | 2018-09-06 00:00:00 | Annual Leave | 7.5
11901 | [NAME] | Human Resources | Level 4 | 2018-09-07 00:00:00 | Annual Leave | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-10-04 00:00:00 | Annual Leave | 2
10201 | Samatha Jones | Procurement | Level 3 | 2018-10-25 00:00:00 | Annual Leave | 7.5
11901 | [NAME] | Human Resources | Level 4 | 2018-10-25 00:00:00 | Annual Leave | 7.5
11901 | [NAME] | Human Resources | Level 4 | 2018-10-26 00:00:00 | Annual Leave | 7.5
11901 | [NAME] | Human Resources | Level 4 | 2018-10-29 00:00:00 | Annual Leave | 3.75
11901 | [NAME] | Human Resources | Level 4 | 2018-11-06 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-13 00:00:00 | Annual Leave | 2.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-14 00:00:00 | Annual Leave | 2.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-15 00:00:00 | Annual Leave | 2.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-16 00:00:00 | Annual Leave | 2
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-20 00:00:00 | Annual Leave | 3.75
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-27 00:00:00 | Annual Leave | 3.75
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-29 00:00:00 | Annual Leave | 3.75
11901 | [NAME] | Human Resources | Level 4 | 2018-11-29 00:00:00 | Annual Leave | 7.5
11901 | [NAME] | Human Resources | Level 4 | 2018-11-30 00:00:00 | Annual Leave | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-11-30 00:00:00 | Annual Leave | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-12-06 00:00:00 | Annual Leave | 4.5
11974 | [NAME] | Sales | Level 4 | 2018-12-18 00:00:00 | Annual Leave | 1
11974 | [NAME] | Sales | Level 4 | 2018-12-20 00:00:00 | Annual Leave | 7.5
11901 | [NAME] | Human Resources | Level 4 | 2018-12-21 00:00:00 | Annual Leave | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-12-21 00:00:00 | Annual Leave | 7.5
10201 | Samatha Jones | Procurement | Level 3 | 2018-04-17 00:00:00 | Sick (Planned) | 1.5
11974 | [NAME] | Sales | Level 4 | 2018-09-27 00:00:00 | Sick (Planned) | 1
11974 | [NAME] | Sales | Level 4 | 2018-10-04 00:00:00 | Sick (Planned) | 1.5
11974 | [NAME] | Sales | Level 4 | 2018-10-05 00:00:00 | Sick (Planned) | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-10-11 00:00:00 | Sick (Planned) | 1.5
11974 | [NAME] | Sales | Level 4 | 2018-10-12 00:00:00 | Sick (Planned) | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-10-25 00:00:00 | Sick (Planned) | 1
11974 | [NAME] | Sales | Level 4 | 2018-11-05 00:00:00 | Sick (Planned) | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-11-06 00:00:00 | Sick (Planned) | 7.5
11974 | [NAME] | Sales | Level 4 | 2018-11-15 00:00:00 | Sick (Planned) | 1
10201 | Samatha Jones | Procurement | Level 3 | 2018-11-28 00:00:00 | Sick (Unplanned) | 7.5