5 Ways to Create a Date 📅 in Power Query

Подписаться 90 тыс.

Просмотров 22 тыс.

50% 1

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 RU-vid Channel Below
ru-vid.com/show-UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

Наука

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 50

@GoodlyChandeep 7 месяцев назад

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

@sabeelahmed1157 9 дней назад

Amazing way of teaching

@wayneedmondson1065 2 года назад

Hi Chandeep. Great date tips for Power Query! Love it when you wrap it all up in one statement. Thanks for demonstrating. Thumbs up!!

@martyc5674 2 года назад

Great Tips- thanks for sharing.

@maryjavasilyevna861 10 месяцев назад

Thank you for detailed explanation, Chandeep!

@franciscom.paredesarias2356 2 года назад

Thank you very much for sharing, Greetings from Chile.

@GeertDelmulle 2 года назад

Very nice! That second trick was quite surprising to me - never would have thought that it would work. Great video! :-)

@viveksharma4193 2 года назад

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.

@atanasprodatanasov9233 Год назад

That video is brilliant!

@GoodlyChandeep Год назад

Glad to hear that!

@killerhunk1 Год назад

You are awesome!!! Thanks a lot.

@GoodlyChandeep Год назад

Glad you think so!

@adnanshaikh2403 7 месяцев назад

Very helpful

@hasnahas972 Год назад

You saved my day with the second trick, thanks a lot

@GoodlyChandeep Год назад

Glad it was useful Hasna!

@wildecorrea6477 2 года назад

The last solution was WACKY, man!!! Congratulations on your videos! 💥🦾👊👏👏👏💯🔝

@GoodlyChandeep 2 года назад

Glad you like it! 💚💚

@ArifulIslam-gs6uy 10 месяцев назад

Great Tips

@eroteam2 Год назад

Man, what a great video, I was trying it for 30 min haha, you helped me a lot!

@GoodlyChandeep Год назад

Glad it helped!

@michellebrayton3570 4 месяца назад

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.

@GoodlyChandeep 4 месяца назад

looking forward to seeing you in the course 🙏🏼🙏🏼😀😀

@thebhaskarjoshi 2 года назад

Great date tips

@GoodlyChandeep 2 года назад

💚

@cosmee510 6 месяцев назад

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

@rakeshchaudhary1110 2 года назад

🙏 it's amezing support

@mirrrvelll5164 2 года назад

Amazing

@rugshavishnu6481 6 месяцев назад

Hi Chandeep, Could you please advise how to treat null values in the date column?

@user-sk5ib4sn3y Год назад

Great video! How did you get the Month from 1 digit to 2 digits? like 1 to 01 ?

@Faisal63045 Год назад

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.

@GJD987 2 года назад

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?

@billgillaspey9036 Год назад

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...

@iugaming6732 2 года назад

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])

@kppaniraj 4 месяца назад

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

@helmutwasser5441 3 месяца назад

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

@kirtithorat4621 2 года назад

How do we change minimum target value after every 3 months in power query and Power BI?

@XenArena 9 месяцев назад

How would you get the date from Year and Week of the Year in Power Query?

@MichalTyborski 2 года назад

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)?

@GoodlyChandeep 2 года назад

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