Working days calculation
Hey Guys im tring to work out the amount of working days and hours bewteen two days for our service level power BI. here is an example of the table in working with, Also with a Close date as null ( due to status) I want to calculate the amount of working days and Hours between open date and "Todays date" Thanks all Dan Ticket Number Status Open Date Close date Amount Working days and Hours 123456 open 27/02/2023 2.00pm Null 654321 closed 28/02/2023 3.00pm 28/20/2023 4.00pm 987654 closed 01/03/2023 1.00pm 02/03/2023 2.00pmFill Blanks with latest if based on sequence
Hello there, I'm having some trouble on solving this one. To give a breif example, we have a sequence from 1 - 5 each with a status and date. Sometimes the user skips this sequence and now I'd like to fill the gap with the latest date available. Example ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 Jan 5 2021 025755 Hot Lead 3 To be filled 025755 Signature Pending 4 To be filled 025755 Success 5 Jan 25 2021 Example2 ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 To be filled 025755 Hot Lead 3 14 Jan 2021 025755 Signature Pending 4 025755 Success 5 Now as you can see we have 2 statuses in example 1 that were skipped and thus have no dates. My objective is to fill these blank spaces for each group(ID) with the latest date available based on the max status/statusID. In example 2, 1 status was skipped and the latest current Id is 3, so we only need to fill the one in between. By default, status(ID) 1 always has a date. Thanks!
