topic Re: Medida DAX para calcular o tempo desconsiderando sabado e domingo in DAX Commands and Tips

Medida DAX para calcular o tempo desconsiderando sabado e domingo

luciano1903 — Thu, 14 Dec 2023 20:12:25 GMT

Boa tarde Pessoal

criei esse medida e gostoria que ela no calculo das horas quando for sabado e domingo nao considera, somente os dias uteis devem ser considerados.

Duracao = DATEDIFF(Certificados[DATA INPUT] , Certificados[DATA DE RETORNO],HOUR)

Qual seria melhor alternativa para realizar esse medida?

Desde ja agradeco pela ajuda

Re: Medida DAX para calcular o tempo desconsiderando sabado e domingo

VahidDM — Fri, 15 Dec 2023 06:20:28 GMT

Hi luciano1903

If the Input and RETORNO columns have date and time then try this:

Duration = VAR StartDate = Certificates[DATA INPUT] VAR EndDate = Certificates[DATA RETORNO] VAR FullDays = CALCULATE( COUNTROWS( FILTER( CALENDAR(StartDate + 1, EndDate - 1), WEEKDAY([Date], 2) < 6 ) ) ) * 24 VAR StartDayHours = IF( WEEKDAY(StartDate, 2) < 6, 24 - HOUR(StartDate), 0 ) VAR EndDayHours = IF( WEEKDAY(EndDate, 2) < 6, HOUR(EndDate), 0 ) RETURN FullDays + StartDayHours + EndDayHours

FullDays Calculation: Calculates the number of full weekdays between the start and end dates (exclusive of the start and end dates themselves) and multiplies by 24 to get the total hours.
StartDayHours and EndDayHours: For the start and end dates, it calculates the hours based on the time of day, but only if they are weekdays.
Final Calculation: Adds the hours from the full days, start day, and end day.

If those columns have Date value only then try this:

Duration = SUMX( FILTER( CALENDAR(Certificates[DATA INPUT], Certificates[DATA RETURN]), WEEKDAY([Date], 2) < 6 ), 24 )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube

Re: Medida DAX para calcular o tempo desconsiderando sabado e domingo

luciano1903 — Fri, 15 Dec 2023 19:04:38 GMT

VahidDM boa tarde

Obrigado pela ajuda, tentei a solucao porem nao consegui esta retornando com o erro abaixo

Re: Medida DAX para calcular o tempo desconsiderando sabado e domingo

luciano1903 — Tue, 09 Jan 2024 17:10:47 GMT

VahidDM

Pode me ajudar com essa solução?

Desde já agradeço.