5 Ways to Create a Date 📅 in Power Query
Вставка
- Опубліковано 3 лип 2024
- Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
In this video I'll share 5 different examples of creating dates in Power Query especially when you don't get a built in date column with your data. Some are easy and the rest are ridiculously easy! Enjoy😁
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
0:25 Eg 1 - Create Dates with Month Number and Year
2:23 Eg 2 - Create Dates with Month Name and Year
4:03 Eg 3 - Create Dates with Year
4:55 Eg 4 - Create Dates with YYYYMMDD Format
6:15 Eg 5 - Change Date format from MM-DD to DD-MM
8:51 Eg 5 - Continued - Change Date Format
12:55 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall UA-cam Channel Below
ua-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - Наука та технологія
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
Amazing way of teaching
Hi Chandeep. Great date tips for Power Query! Love it when you wrap it all up in one statement. Thanks for demonstrating. Thumbs up!!
Great Tips- thanks for sharing.
Thank you for detailed explanation, Chandeep!
Thank you very much for sharing, Greetings from Chile.
Very nice! That second trick was quite surprising to me - never would have thought that it would work.
Great video! :-)
Thank you very much, sir, I'm struggling with this concept often .. but the last trick is so cool .. will help a lot in my future assignment.
That video is brilliant!
Glad to hear that!
Great Tips
You are awesome!!! Thanks a lot.
Glad you think so!
Very helpful
The last solution was WACKY, man!!! Congratulations on your videos! 💥🦾👊👏👏👏💯🔝
Glad you like it! 💚💚
You saved my day with the second trick, thanks a lot
Glad it was useful Hasna!
Man, what a great video, I was trying it for 30 min haha, you helped me a lot!
Glad it helped!
I have really enjoyed your style of teaching. You are really a master of breaking it down and making it look easy. Thank you for your content. I have learned more in a day of watching your videos then I have in weeks, struggling to learn all that is possible with Power Query. Your explanation of the difference between Excel Power Query and Power BI.... was priceless.... I now know exactly what Power Query in Excel is... Power Pivot etc... Thank you. I am going to sign up for your class on the M language.
looking forward to seeing you in the course 🙏🏼🙏🏼😀😀
Great date tips
💚
Hai Goodly ,
I have an issue
In power query editor date column is in format dd-mm-yyyy
But I created in the format of yyyy-mm-dd
Using
Text.From(Date.Year([loaddate])) & "-" & Text.From(Date.Month([loaddate])) & "-" & Text.From(Date.Day([loaddate]))
The output is come in yyyy-mm-dd
But I am trying to convert into date data type
This custom column values also changing into dd-mm-yyyy
What should I do now ...
I tried many ways ...
Kindly help
🙏 it's amezing support
Amazing
Hi Chandeep,
Could you please advise how to treat null values in the date column?
Great video! How did you get the Month from 1 digit to 2 digits? like 1 to 01 ?
Hi is there a formula or PQ way to change any transactions time that come between 12:00:00 AM and 7:59:59 AM To be 8:00:00 AM which is the start of working hour.
Great video as always - My issue with dates is :
I frequently get an issue with dates in that when the data is loaded to excel, they revert to numbers in the spreadsheet. This is even though the data type is set to date in PQ. Fixed by changing the formatting of the cells in Excel to date , but a data refresh brings back the issue, requiring re-formatting
Why does this happen and how can it be fixed ?- many thanks
The same issue here. This is a crazy behavior when you process this date values in VBA. Filters created by code doesn't work.
Did you find any solution in past months?
The final method, no doubt, looks nice since everything is done in a single step. But it does beg the question: is there a purely technical basis for calling it "better" than doing the transformation using multiple steps? I.e., Could one, perhaps, to measure the speed (or maybe there is a better metric) of "one step" code vs code in several PQ steps? just curious...
Hi Chandeep,
I watched some of your videos and all are great. I want to ask my dax issue but it is not related to your topic.
Can you tell me what's wrong why I get correct data on 8 but not on 7?
Tickets for 7 days = CALCULATE(COUNTA('Tickets'[Ticket ID]) , FILTER (('Tickets', 'Last Refresh'[Date.Last Refreshed] - 'Tickets' [Created])
Can we solve a problem where a couple of dates are in Indian format and couple are in American format in the same column and I want only the dates in American format to be converted to Indian Format, Please guide
Hi Chandeep, thank you for your video but in my case, it did not help me. Could you help me with this issue. I have a data import from hundreds of CVS files, and they all look the same. The date does not come as a real date. I am getting for example in the Date Row 45371.49955 and I cannot get that converted to a Date. I checked that in excel and easily got a DateTime --> 20.03.2024 11:59:21
How do we change minimum target value after every 3 months in power query and Power BI?
How would you get the date from
Year and Week of the Year
in Power Query?
Hi!
I have a question from example 2. How to do it in DAX?
I have month (April) and year(2022), how to make from these 2 columns column date(2022-04-01)?
Create a new column, something like this
Date Column = DATEVALUE ( "1-" & Table[MonthName] & "-" & Table[Year] )
The order of concatenation - DD-MM or MM-DD will depend on your local PC settings. But this should work
I have a start date and end date. I want to create a list of month start dates between the from and to dates.
ua-cam.com/video/tnjzIq7jinQ/v-deo.html
Hi Sir
How can we add extra day for already in date column
You mean date + 1?
If yes you can use the formula =Date.AddDays([Date] + 1)
How to convert month name to month number
Create a new column in power query and use this code
= Date.Month ( Date.From ( [MonthNameColumn] & "2020" ) )
Hi Chandeep, nice video indeed. But what I need is to how to get yyyy-mm and mmm-yyyy out from the date.
Can you please kindly help with that?
Dear bro,
I need to second last max date with multiple criteria in power query
How to create M function
So usefull
Glad it was useful!