Posted 20 hours ago

SwiftGlimpse Large A0 Blank Reusable One Month Wall Calendar Wet Erase Laminated Monthly Wall Planner (122cm x 91cm)

ZTS2023's avatar
Shared by
Joined in 2023

About this deal

As well as being something you can treasure rather than throw away after using, a fabric advent calendar allows you to choose bespoke token gifts the recipient will love. Whether favourite chocolates, festive nik naks, mini toys, stationery or even little notes with Christmas activity ideas, there is so much scope for how you can make this a personalised advent calendar. Plus, filling your own advent calendar can often be cheaper than buying one from scratch. mini bars in a mix of four scrumptious flavours (Smooth, Hazelnut, Fruit & Nut, Salted Caramel Truffle) From the documentation above, I can see that there are no parameters required for this function. So I just added () to the end of the function to return the current date/time. You can see once again that this is a scalar value (not a table) because you can “see” the value below the formula bar. To teach you how to create a calendar table in power query, I am going to use Power BI Desktop as the tool for this, but of course Power Query for Excel will work just as well and the process is identical. In fact the calendar query at the end can easily be cut and pasted between Power BI and Power Query for Excel. Step 1: Create a list of dates There are plenty of options when it comes to filling your reusable advent calendar. You can keep it simple with sweets, chocolates, or homemade biscuits, of course, or you could pop decorations inside each pouch to add to the Christmas tree each day. You could also try wrapped gifts (small trinkets and toys work well), or even clues to festive activities that you have planned for the day ahead. The world is your oyster, quite frankly!

Note that the start date is hard coded as 1/1/2016 and the calendar is set to load 100 days. Below I will show you how to make the start date easier to maintain and the end date automatically set to the current date. Start Date Added Custom” = Table.AddColumn(#”Fiscal Source”, “Date ISO8601”, each Date.ToText([Date], “YYYY-MM-DD”)) I think the secret to make a good reusable calendar is really knowing the person you are gifting it to so you can choose things that they will definitely like,' adds Alessia. What to look for in a reusable advent calendar? My new code (1 above) correctly calculates the financial year (shown in 2). Note I also changed the default column name to “Fin Year” to avoid confusion with calendar year. Add Other Columns So even if you are not a sustainability advocate you should still think about creating a special treat for your loved ones this Christmas,' she says. FAQs: What are the benefits of a reusable advent calendar?Inserted Month Name" = Table.AddColumn(#"Inserted Year", "Month Name", each Date.MonthName([Date]), type text), Added Custom1" = Table.AddColumn(#"Added Custom", "MonthID", each (Date.Year([Date]) - Date.Year(StartDate))*12 + Date.Month([Date]))

Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),Inserted Month" = Table.AddColumn(#"Inserted Day Name", "Month", each Date.Month([Date]), Int64.Type), Great. Now the user can manually change the StartDate step to any date, and the calendar will auto grow in length. Actually this code will grow up to yesterday’s date. You can simply add 1 to the Length to make it grow up to and including the current date.

Just by looking at the UI above (red box), you can see that there is some strange data format returned. You can probably work out this data is in the format DDD:HH:MM:SS. This “duration” format wont work in the next step I am about to show you, so first I needed to extract an integer portion of the duration so it contains just the days. I did this using a function called Duration.Days below.

Learn to be a Power Query Expert

Here is the new code. I also renamed this step to “Length”. You can see in the image below that this is now an integer value. My approach to teaching people to use Power Query is to always use the UI where possible. I first use the UI to do the hard work, then jump in and make small changes to the code created by the UI to meet any specific variations required. Keep this concept in mind as you read this article.

Asda Great Deal

Free UK shipping. 15 day free returns.
Community Updates
*So you can easily identify outgoing links on our site, we've marked them with an "*" symbol. Links on our site are monetised, but this never affects which deals get posted. Find more info in our FAQs and About Us page.
New Comment