I have a dataset where I have various activities with the primary two in question is paid hours and absence hours.
We measure long term absence as five days of absence in a row, in which all dates from the start to end of absence period is to be marked as LTA.
Am not familiar enough with DAX to work out a calculation for this if it was python testing would be fine but in work we primarily deal with DAX and power pivot.