Hi Doug, I have a question about making cluster bar charts in Excel. Specifically, how do we align to the left very long labels for a bunch of statements on the Y axis? Thank you
Hi Doug, this is the best video I have seen on creating a dynamic 445 date table. However, I need to take it one step further to include 2 week columns- one col for sequential week numbers and another sequential week numbers which start again each year. Yes, each year has 52 weeks spanning 364 days. I have got the week number but it is derived from calendar year. Many thanks in advance
Thanks for the great video. Additionally, if you would like just a year that changes every 364 days. You can use the following ; (#"StartYear") + ([year_id]-1) Start year being the year the calendar starts i.e. 2015 etc..
Thanks for the tutorial. I have a quick question...if I have a two years calendar (445 calendar), for the fiscalqtr, do I need to change the "4" to 8 in the formula? Thank you for your help.
Excellent tutorial, and very helpful. Do you have any advise on how to expand the Fiscal Month to include all twelve months and add a Fiscal Weekly column as well. I am working with a 454 retail calendar that starts in February and have data from Feb 2018 to current.
one option is to look at the change in pattern of the values in the quarter column and then add another column to mark it with that row's date. Maybe a future video...
PQ can pull out the week of the year (ua-cam.com/video/9rI4WayyApA/v-deo.html) and then you may need to add a helper column to offset (+/-) the number of weeks from the calendar week number.
Thanks for video! I have a question about 53 weeks. Calendar is mixed with 52 weeks and 53 weeks. In my case, 52 weeks untill fy2019, 53weeks for fy2020 and 52 weeks from fy2021. I use “if” to fy2020 and divided it to 371, but it didnt work properly. I wonder the proper formula to use in the case. I’d appreciate your help. Thank you
Hello ; I congratulate you on the very important and instructive tutorials. I would like to calculate the cumulation per fortnight and per month and camparer it on the same date of the previous campaign (which begins in June and ends at the end of May) by power BI. Could you tell me what should I do please? Thank you in advance
So I am creating a calendar based on the first and last day of the month in the 4-4-5 calendar. For instance, the first day of the month would be 31/07/2016 and the last day would be 27/08/2016 in a column next to it. Would it be hard to achieve this?
Hello sir, the video helped me alot but I have a ques for month ID column, I want to start my week with 1st after every 12th week. Could you help me in this?
Hi Doug, I have a question about making cluster bar charts in Excel. Specifically, how do we align to the left very long labels for a bunch of statements on the Y axis? Thank you
maybe something like this? ua-cam.com/video/ukloNXrFyB4/v-deo.html
Hi Doug, this is the best video I have seen on creating a dynamic 445 date table. However, I need to take it one step further to include 2 week columns- one col for sequential week numbers and another sequential week numbers which start again each year. Yes, each year has 52 weeks spanning 364 days. I have got the week number but it is derived from calendar year. Many thanks in advance
nice one thumbs up
Thanks fab mic!
Thanks for the great video.
Additionally, if you would like just a year that changes every 364 days. You can use the following ;
(#"StartYear") + ([year_id]-1)
Start year being the year the calendar starts i.e. 2015 etc..
Thanks for sharing!
Thnx 😊
Welcome 😊
Thanks for the tutorial. I have a quick question...if I have a two years calendar (445 calendar), for the fiscalqtr, do I need to change the "4" to 8 in the formula? Thank you for your help.
Excellent tutorial, and very helpful. Do you have any advise on how to expand the Fiscal Month to include all twelve months and add a Fiscal Weekly column as well. I am working with a 454 retail calendar that starts in February and have data from Feb 2018 to current.
Adding helper columns that pull in the month from the fiscal month and offset calculation to a week number column may help
First off, this was very helpful, thank you. How would I add the start and end of each month to this?
one option is to look at the change in pattern of the values in the quarter column and then add another column to mark it with that row's date. Maybe a future video...
Thank you for this! this was great. How can I use the fiscal query with data I already have in excel?
Thank you
You're welcome
Many Thanks for this video. Only one question: how can I create a WeedID ? Many Thanks in advance for your help !!
PQ can pull out the week of the year (ua-cam.com/video/9rI4WayyApA/v-deo.html) and then you may need to add a helper column to offset (+/-) the number of weeks from the calendar week number.
Thanks for video! I have a question about 53 weeks. Calendar is mixed with 52 weeks and 53 weeks. In my case, 52 weeks untill fy2019, 53weeks for fy2020 and 52 weeks from fy2021. I use “if” to fy2020 and divided it to 371, but it didnt work properly. I wonder the proper formula to use in the case. I’d appreciate your help. Thank you
Hello ;
I congratulate you on the very important and instructive tutorials.
I would like to calculate the cumulation per fortnight and per month and camparer it on the same date of the previous campaign (which begins in June and ends at the end of May) by power BI. Could you tell me what should I do please?
Thank you in advance
Hi Aicha Khadir, sorry I don't do consulting 🙁....but try a post on the mrexcel.com forum!
So I am creating a calendar based on the first and last day of the month in the 4-4-5 calendar. For instance, the first day of the month would be 31/07/2016 and the last day would be 27/08/2016 in a column next to it. Would it be hard to achieve this?
It's only one of the fiscal four week month of 28 days, but I suppose it can be done.
Hello sir, the video helped me alot but I have a ques for month ID column, I want to start my week with 1st after every 12th week. Could you help me in this?
Also I want to add another column in the table for weeks of calendar but it should starts with 1 and end with 52/53. Kindly help
How can I get month day for each month. Thanks
In the PQ Editor, Add Column tab, in the Date & Time group, click the Date command icon and it will give you the option to get the day.