MIN filter not returning expected result
Hi I would like to return the minimum value based on the selection criteria used. Using the min function does not return the expected result. Please see below examples. Maybe I am overseeing something. Great if anyone can help. In below measure I calculate the minyear (minimum year selected on page filter is 2021) and use it in the filter. This does not return the desired outcome as it also returns values in 2022. In below example I do the same, however, the filter is not based on a minimum but on a year defined, in this case 2021. This is the desired outcome as it is not showing 2022 values. Below the filter used on the page.get MIN, MAX DATE then count duration in hour
hi all; i have data set, https://docs.google.com/spreadsheets/d/159xOcmrKj95YXYOayHmGi9A_K_8ZHIMq/edit?usp=sharing&ouid=100079262241875009342&rtpof=true&sd=true the point is; i already get MIN DATE, and MAX DATE ( with Measurement); but then how to get duration(hour) from that ? i tried using DATEDIFF formula but the result is wrong . First Started = CALCULATE ( MIN ( 'Data'[DateStarted] ), ALLEXCEPT ( 'Data', Data[DateCreate], Data[worker] ) ) Last Finished = CALCULATE ( MAX ( 'Data'[DateFinished ), ALLEXCEPT ( 'Data', Data[DateCreate], Data[worker] ) ) duration(hour)= datediff([Last Finished] , [First Started],HOUR) thank you for your help; Azura
Night shift (logic, calculation)
Hi everybody, I'm looking for a solution, but I can't find it. I would like to know the time worked. Info: - People work in the morning, afternoon and night. Overtime is also possible. - Thousands of posts are made in a day, that's thousands of time data. So there is not only a beginning and an end. - Morning shift: 06-14 (can be overtime: 02-14, 06-18) - Afternoon shift: 14-22 (can be overtime: 10-22, 14-02) - Night shift: 22-06 (can be overtime: 18-06, 22-10) MIN - MAX works in the morning and in the afternoon, because the time data comes one after the other. It does not work at night because it is separate, e.g.: 0:00 (start) -> (end) 6:00 + 22:00 (start) -> (end) 0:00. This is a MIN - MAX 24h. time worked = VAR balans = CALCULATE ( MAX (EVENTHistory[hour]), FILTER ( ALLSELECTED ( 'EVENTHistory' ), EARLIER (EVENTHistory[worker]) = 'EVENTHistory'[worker] ) ) - CALCULATE ( MIN (EVENTHistory[hour]), FILTER ( ALLSELECTED ( 'EVENTHistory' ), EARLIER (EVENTHistory[worker]) = 'EVENTHistory'[worker] ) ) RETURN FORMAT ( INT ( balans * 24 ), "00" ) & ":" & FORMAT ( INT ( MINUTE ( balans ) ), "00" ) & ":" & FORMAT ( INT ( SECOND ( balans ) ), "00" ) Thank you in advance for your help.
Count of Projects from Min Stage to Max Stage Display in Matrix Visual
Hi Everyone, I am trying to create matrix visual based on my sample data for project transition, based on date of status change selection my projects from stage and to stage should be changed and always I should showcase latest stage for project Sample Input: Expected Output When I Select Date From 11-16-2021 to 5-25-2022 or after When I Select Date From 11-16-2021 to 5-24-2022 Always project status transition is from Latest From Status to Latests To Status. Thanks Advance for your help!
