Extract Start and End Dates with Power Query - 2 Ways - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
imran
Hi, your videos are worth watching. I have a real scenario and want to get your guidance.
I am a SAP user, I receive more than 200 claims/month and same are approved by different person in following way,
Approver 1 receive claim SAP shows status 900, and when he approves it show status as 50 or 68. After first approver , it flows to 2nd approver and shows status as900 and if 2nd approver is on leave then it flows to back up approver showing status as 900 untill claim reaches final approver and when it finally approved it shows status as 70
So for each claim lot of duplicates showing status 50, 68 and 900
My manager asked me to write in column angainst each claim approver name and how much time taken by each for approving
Date of receiving/approving is mentioned in
SAP , please guide how to do
Thanks
Imran
reply
Hi, your videos are worth watching. I have a real scenario and want to get your guidance.
I am a SAP user, I receive more than 200 claims/month and same are approved by different person in following way,
Approver 1 receive claim SAP shows status 900, and when he approves it show status as 50 or 68. After first approver , it flows to 2nd approver and shows status as900 and if 2nd approver is on leave then it flows to back up approver showing status as 900 untill claim reaches final approver and when it finally approved it shows status as 70
So for each claim lot of duplicates showing status 50, 68 and 900
My manager asked me to write in column angainst each claim approver name and how much time taken by each for approving
Date of receiving/approving is mentioned in
SAP , please guide how to do
Thanks
Imran
reply
K.
Thank you so much for all of your videos. I am trying to learn a way to determine monthly totals if I have a list a list of customers, their monthly fixed amount and their start and end dates. The query would have to add their monthly amount only to each month's tally, only if the month being tallied falls between the start date listed in one column and the end date listed in another column. If there is no end date, they are still an active customer and would be tallied up and including the current month. Have you done any videos that describe how to set up such a tally?
reply
Thank you so much for all of your videos. I am trying to learn a way to determine monthly totals if I have a list a list of customers, their monthly fixed amount and their start and end dates. The query would have to add their monthly amount only to each month's tally, only if the month being tallied falls between the start date listed in one column and the end date listed in another column. If there is no end date, they are still an active customer and would be tallied up and including the current month. Have you done any videos that describe how to set up such a tally?
reply
GIRISH
Hi mam,
Blow are Seanario for one example:-
A is employee name.
X, y, z project names.
Total allocation 100%.
A is 30% allocated to -X- project with start date is 1st Mar 2022 and end date is 15th march 2022,
A is 30% allocated to -Y- project with start date is 17th Mar 2022 and end date is 24th March 2022
A is 40% allocated to -Z- Project with start date is 26th Mar 2022 to 30th Mar 2022.
So how to find out date gap is 16th, 25th 31st is missing..
reply
Hi mam,
Blow are Seanario for one example:-
A is employee name.
X, y, z project names.
Total allocation 100%.
A is 30% allocated to -X- project with start date is 1st Mar 2022 and end date is 15th march 2022,
A is 30% allocated to -Y- project with start date is 17th Mar 2022 and end date is 24th March 2022
A is 40% allocated to -Z- Project with start date is 26th Mar 2022 to 30th Mar 2022.
So how to find out date gap is 16th, 25th 31st is missing..
reply
S.
Thanks a lot for your videos. My issue is: i have 2 columns. In the first i have number 1 which is January first month, and in the second column i have 2021. I want to create a third column in which I want to have the full date : 31.01.2021. Same for number 2 which is February. How to do it ?
reply
Thanks a lot for your videos. My issue is: i have 2 columns. In the first i have number 1 which is January first month, and in the second column i have 2021. I want to create a third column in which I want to have the full date : 31.01.2021. Same for number 2 which is February. How to do it ?
reply
Younes
Thanks a lot!
I have one question!
how can you get the function visible on the formulas barre while you are tapping, I sought avey where on the internet but unfortunately I haven't found anything.
regards
YMB
reply
Thanks a lot!
I have one question!
how can you get the function visible on the formulas barre while you are tapping, I sought avey where on the internet but unfortunately I haven't found anything.
regards
YMB
reply
Mohmmad
Thanks a lot -
I have a question ..
I start power query and I import the data by chosen -only creat connection- and Add the data to the model,
-Can I transfer the data to table (povit table) any time I need ?-
reply
Thanks a lot -
I have a question ..
I start power query and I import the data by chosen -only creat connection- and Add the data to the model,
-Can I transfer the data to table (povit table) any time I need ?-
reply
Nathan
This is helpful! Can we do this in reverse? e.g., we have a report with -start date- and -end date- on each column, is that possible to break it down into the format just as your original dataset?
reply
This is helpful! Can we do this in reverse? e.g., we have a report with -start date- and -end date- on each column, is that possible to break it down into the format just as your original dataset?
reply
Wayne
Hi Mynda.. awesome techniques. Thanks for showing two approaches and for emphasizing the performance consideration.. something to keep in mind when developing solutions.. excellent! Thumbs up!!
reply
Hi Mynda.. awesome techniques. Thanks for showing two approaches and for emphasizing the performance consideration.. something to keep in mind when developing solutions.. excellent! Thumbs up!!
reply
Nagesh
Hi Mynda, if we have a situation where format is month/date and year is not mentioned. Need to check if this date is 7 days old from current date...can you help in building logic.
reply
Hi Mynda, if we have a situation where format is month/date and year is not mentioned. Need to check if this date is 7 days old from current date...can you help in building logic.
reply
Cherian
-MyndaTracy and team... Happy New Year 2021! You are awesome at this! Thank you for breaking this down so easily! Virtual Hug! Elbow Bump! Take care, stay safe!
reply
-MyndaTracy and team... Happy New Year 2021! You are awesome at this! Thank you for breaking this down so easily! Virtual Hug! Elbow Bump! Take care, stay safe!
reply
Add a review, comment
Other channel videos
