User Profile

DonPepe

Helper II

Joined 5 years ago

36 Posts6 LikesLikes received1 Solution

View All Badges

User Widgets

Contributions

Mean as a vertical line in a skewed distribution
Hi, I have a chart like the one below and I want a vertical line representing the mean in this chart. Do you know how I can manage to get that ? My data are like the one below : I have a Key which is a text value and a duration. I construct the graphic by counting the number of key for each duration. Thanks a lot for your help, Don
3 years ago Place Desktop
Need Help
522Views
0likes
0Comments
Re: Find element in another table based on DateTime range
Hi v-xiaotang , Thanks for your help ! Unfortunately I had the same results than my previous measure, so finaly I did multiple merges in Powerquery and now I have what I want. Thanks again for your help, Don
3 years ago Place Desktop
642Views
1like
0Comments
Re: Find element in another table based on DateTime range
Hi, I already try with the measure below but I dont have the record if the actual route occure before midnight. LinkPlannedActBis = var _minDateTime = MAX(StagPlannedData[PlarouDateTime])-TIME(2,0,0) var _maxDateTime = MAX(StagPlannedData[PlarouDateTime])+TIME(2,0,0) return IF( MAX(StagPlannedData[PLAROU Code])=MAX(StagFullYearDLL[ACTROU Code]) && MAX(StagFullYearDLL[ActrouDateTime])>_minDateTime && MAX(StagFullYearDLL[ActrouDateTime])<_maxDateTime, "Y", "N" ) Fyi ; StagFullYearDLL = Actual table Regards, Don
3 years ago Place Desktop
723Views
0likes
0Comments
Find element in another table based on DateTime range
Hi, I struggle to link two element in two different table. So I have two table ; "Planned route" and "Actual route". I want to compare if all my planned rout are well executed. For example; for the planned route "0004264" planned at 00h20 on 6/10/2022 I need to check if I find a record in my actual table of "0004264" with "ActrouDateTime" between 5/10/2022 22h20 and 6/10/2022 02h20 (PlarouDateTime + and - 2 hours) Thanks for your help, Don
Solved
3 years ago Place Desktop
Need Help
725Views
0likes
3Comments
Re: Open Tickets
Hi Greg_Deckler , Thanks for your insight ! it's really sexier than my old solution. I managed this situation in Power Query by creating a list of all date between my "open" and "close" date and counting the number of different ticket each day. It works but I got a ton load of line. Regards, Don
3 years ago Place Quick Measures Gallery
36KViews
0likes
0Comments
Re: Convert List in Function
Woah, so nice, thanks a lot. I am not familiar with expression like this (x)=> Date.DayOfWeek(x) I will try to study more on that 🙂 Have an excellent day !
4 years ago Place Power Query
2.7KViews
0likes
0Comments
Re: Convert List in Function
Yeah sorry, PLAOSP Start Day In Week is the name of the field, I simplified it by "DAY_IN_WEEK" in this example.
4 years ago Place Power Query
2.8KViews
0likes
2Comments
Re: Convert List in Function
Hi Vijay_A_Verma, Thanks a lot for your answer, it's ok for this example. I just include it in a new column. Table.AddColumn( Source, "DateList", each List.Select( List.Dates( Date.FromText(StartDate), Duration.Days(Date.FromText(EndDate) - Date.FromText(StartDate)) + 1, #duration(1, 0, 0, 0) ), each Date.DayOfWeek(_) = 2 ) ) Now I would like to have the same result but for any kind of value in the field "DAY_IN_WEEK" I tried this but I have an error : Table.AddColumn( Source, "DateList", each List.Select( List.Dates( Date.FromText(StartDate), Duration.Days(Date.FromText(EndDate) - Date.FromText(StartDate)) + 1, #duration(1, 0, 0, 0) ), each Date.DayOfWeek(_) = Number.From([DAY_IN_WEEK]) ) ) the error : "Sorry... We couldn't apply field access to the Date type. Details : Value=05-11-23 Key=PLAOSP Start Day In Week" Thanks a lot, Don
4 years ago Place Power Query
2.8KViews
0likes
4Comments
Convert List in Function
Hi, My goal is to get all the working date for a service from a given Start date and a given End date knowing that I know only the day of week and the service validity. Parameters : Start date = 21/6/2022 End date = 15/7/2022 Data : Service ID Service_FREQUENCY DAY_IN_WEEK Service validity start date Service validity end date SDF1232 1234 2 12-06-22 31-12-25 So the service SDF1232 work from Monday (frequency 1) to Thursday (Frequency 4) and here I have the record of Thuesday (frequency 2 = day in week 2) his validity is from 12-06-22 to 31-12-25. Basicaly, here, I want all the Thuesday between Start date 21/6/2022 and end date 15/7/2022 since the two parameters are included into the service validity date. The think to choose the range between the parameters or the service validity is ok. Where I strugle is how can I get the list of each Thursday. I tried like this but I have an error that Power Query cannot convers list type to function type and I dont know how to resolve it. let Source = RawFlexiView, ListDayWeek = Table.AddColumn( Source, "Date", List.Select( {Number.From(Date.FromText(StartDate)) .. Number.From(Date.FromText(EndDate))}, each Date.DayOfWeek( _, Lines.ToText( List.First( List.Range( { Day.Sunday, Day.Monday, Day.Tuesday, Day.Wednesday, Day.Thursday, Day.Friday, Day.Saturday }, Number.From([PLAOSP Start Day In Week]), 1 ) ) ) ) = 0 ) ) in ListDayWeek If I dont use the right strategy tel me also, I am quite new on Power Query. Thanks a lot for your help, Don
Solved
4 years ago Place Power Query
Need Help
2.8KViews
0likes
7Comments
Re: Average total of each average at a row level if condition
Hi DataInsights, Thanks for your help, it seems that's on a good way because I have now 57.1% but still not the 57.7%. I think it's because I can have several line per ID so sometimes SubcoScanning[Capa Theoric] > SubcoScanning[NbrContainer] and sometimes SubcoScanning[Capa Theoric] <= SubcoScanning[NbrContainer] for a same ID. Still making some test, I will keep update if it works. Thanks, Don
4 years ago Place Desktop
1.6KViews
0likes
0Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.