AZA: Split Absence Entries

Hi Team,

Does anyone know how can we split the absence entries.

Example: If employee applies for a 3 days sick absence from 01-May-2022 to 03-May-2022 (single entry with absence start date May1 and end date May3). When we query the data in the BI we will get a single record but how can we split the absence into 3 rows with like below

Date Duration

01-May-2022 1

02-May-2022 1

03-May-2022 1

Any pointers much appreciated

Thanks in advance

Regards,

Ahmed