 and number one in our list is what let's see hold the control and click well guys now clicking let me just manually go to number one all right so number one is call up function help and using m intelligence call up function help so let's assume you don't know the function you want to use let me just go to a blank query how do I get a list of functions I don't know the function I want to use so if you go to a blank query you simply type equals to you type your hash key and you type shared yeah equals to a hash key shared now I don't know why they called it shared they should I just called it equals hash key power query functions or something shared anyway when I enter you will see a list of everything power query I mean all the functions are there so the nice list of functions all sorts of stuff so really if you want to see this as a table let's let's convert it into a table yeah so I convert it into a table and if I was in excel I could just load this into excel and you see all the list of functions but really why I did that is if you click on any one of this you would see the explanation of that function really so let's pick something let's do let's come here and do a list we're going to look for a function called list dates it's going to list dates so I'm just typing list there dot maybe dates so here this is this is the function I want to see this one so click okay so this list days I'm just going to click on the function button here so this is the function so I just click on the function button explains what the function does you can read everything about it here so let's create a a list of dates right I want to create a list of dates typically you click on this button to say what is your start when are you starting what are you starting so let's assume I want to start on the first now look at this the input value one September did not pass using local English United Kingdom and short date format dmmmyyy now all this is telling you this is quite annoying this is saying that the way I'm writing my date the computer basically knows it as United Kingdom dates but this system is looking for this button here is looking for an American date so I just I just have to manually type let's say one slash nine slash 20 18 now for most of most of you to work fine well for me it's not working fine because I'm using the UK dating system my UK dates if I go to my control panel you see that my date is UK but I'm going to that it's looking for a US dating system by any way one nine twenty eighteen is my computer's dating system count let's say we want to start let's say I just want 30 days right 30 days and then my step is one day each so 30 days starting from first of January give me 30 days one day per interval say okay so see what it does it gives me first of September to the end how did I know that because I went to look for a list of functions I wanted a list of dates and we see now I have a list of dates I can now convert this to a table by coming to the top left and saying to table so now this you can just ignore this and say okay so this is now a table I can double click this heading and say this is my date enter and then I can convert this to a data type of date instead of any I call party to date and I'm in business so this is my date and I can close let me not close and load close and apply or just apply what I've just done let's call this date list or well I've converted to a table so it's not really a list but anyway date table right so date table so you get the idea but really we got this by using function we identified we had a list of functions or something list functions yeah now that was our first trick so I enter