I have a complicated case and need your help, its table which connected in BI, the first column is system date and 2nd column is the arrival of guest and third is the departure of the guest, normally system count as stay period i.e. if guest arrival on 29th of Dec 2019 and departure on 1st of...