5 Ways to Create a Date in Power Query

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

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

Very helpful

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

Great Tips

Thank you for detailed explanation, Chandeep!

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

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?

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

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

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

So usefull

That video is brilliant!

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.

You are awesome!!! Thanks a lot.

Great date tips

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

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

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

Hi Sir

How can we add extra day for already in date column

Amazing

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

Please help. Thank you.

Great Tips- thanks for sharing.

Dear bro,

I need to second last max date with multiple criteria in power query

How to create M function

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

Thank you very much for sharing, Greetings from Chile.

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

How to convert month name to month number

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

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.

I have a start date and end date. I want to create a list of month start dates between the from and to dates.

🙏 it's amezing support