Lukket

Use Power Query to create a custom 4-4-5 Calendar Table with offsets based on today

I am looking use Power Query to create a custom 4-4-5 Calendar table with offsets.

I have attached an example of what I want as an excel file.

Below are some of the "rules" that apply to the calendar and where I've struggled:

(1) Weeks run from Sunday to Saturday

(2) If Jan 1st falls between Sunday and Tuesday, the fiscal month [[login to view URL]] for January will end on the 4th Saturday. If Jan 1st falls between Thursday and Saturday, then January's [[login to view URL]] will end on the 5th Saturday.

(3) There is a column that returns Today's fiscal month [[login to view URL]] as a number. For example, if today were April 29th, its fiscal month [[login to view URL]] would be 5 not 4.

(4) Each year ends on December 31st (extra days from the 28day-28day-35day pattern are added into December

(5) There are index numbers for each day/week/month of each year

(6) The calendar runs from 2017 to 2020

Evner: Dataindførsel, Databehandling, Ingeniørarbejde, Excel, Matematik

Se mere: create custom table visio shape, create custom table headers myspace, sugarcrm create custom table, 4-4-5 calendar 2019 excel, 4-4-5 calendar 2018 excel, list.dates power query, excel formula for 4 4 5 fiscal calendar, 4–4–5 calendar algorithm, custom fiscal calendar in power query, power query 445 calendar, create 4-4-5 calendar in excel, create custom logo power ranger, create custom webpart query database, visio create custom table, access create custom error message duplicate index values table, access create custom query sql, create slides excel use power point, linq sql create custom query provider, create custom gridview control use project, power bi create new table from existing table

Om arbejdsgiveren:
( 0 bedømmelser ) Warwick, United States

Projekt ID: #19347421

14 freelancere byder i gennemsnit $149 på dette job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Flere

$220 USD in 3 dage
(324 bedømmelser)
7.9
daniyal3214

I can definitely help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of various data analytics softwares including Excel, Tab Flere

$100 USD på 1 dag
(50 bedømmelser)
5.4
tiaratechies

Hello, I have experience in power query and I'm a certified advanced excel expert with a decade of experience if you hire me I'll deliver the work up to your satisfaction.

$250 USD in 3 dage
(39 bedømmelser)
5.2
TopDesigner315

Dear,sir. How are you? I read your project with great interest. We will make every effort to understand your intentions and satisfy you. I will not let you down with a blank and misshapen. I will wait Flere

$100 USD på 1 dag
(2 bedømmelser)
2.8
IbexEnterprises

Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from cli Flere

$100 USD in 3 dage
(7 bedømmelser)
2.1
bluestar1027

Hi Dear. Don't worry for your project, i can do your project completely. Because of i'm dedicated and created developer for project and love to develop for you. if you don't satisfy my result, i will return your mon Flere

$155 USD in 3 dage
(1 bedømmelse)
1.8
milindaudichya

Hi, I just checked your requirements and I know that you receive hundreds of proposal so without wasting any time let jump on a chat and get started. You can check my skills and work I did in my profile. Current w Flere

$122 USD in 3 dage
(1 bedømmelse)
1.3
mgsrajib

I want to do this. I can do this well. I will be able to finish this task within the due time. I can do exactly as you wanted.

$155 USD in 3 dage
(0 bedømmelser)
0.0
Ranupooja

I can help , but I would like to now more details about this project. please share more details related to this project.

$155 USD in 3 dage
(0 bedømmelser)
0.0
kkofahe13

I’m able to use my skills as a programmer to write a code to automate the process Which will results in more productivity and accuracy in addition to reuse ability for more what required

$111 USD in 3 dage
(0 bedømmelser)
0.0
mrla11

We are data specialists with a proven background in data discovery, definition, integration and management. We are very proficient with all Microsoft office applications. We have a lot of previous experience with data Flere

$155 USD in 6 dage
(0 bedømmelser)
0.0
Helenstuart0

Hi Dear, Having elevated the performance and profitability of diverse organizations through expert alignment of innovative marketing and advertising strategies, I am writing to offer your company more than 6 years o Flere

$155 USD in 3 dage
(0 bedømmelser)
0.0
Rashed7671

Data Entry via google docs, Excel, Word, web based software, CMS > Google Map Lookup: Searching for businesses in different industries worldwide and finding their complete addresses, phones, and URL's. > Google Earth Flere

$155 USD in 3 dage
(0 bedømmelser)
0.0
ahmadaskar

Hello, Pretty interesting gig Since i am on it and i have the initial calendar in place let Source = Years, #"Converted to Table" = [login to view URL](Source, [login to view URL](), null, null, ExtraVa Flere

$150 USD in 3 dage
(0 bedømmelser)
0.0