cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TJCappy
Frequent Visitor

Convert Date to text and keep the leading 0

Hi All,

 

I am trying to use a date and username to create a key.  

It would seem simple enough but I am strugling with converting the date to text.

 

The issue I am having is with sindle digit days/months.

 

when I convert 2022-01-01 to text i get 1/1/2022 and I need to have 01/01/2022.

when I remove the slash "/"  I am now left with 112022  and what i need is 01012022.

 

If you know a way of doing this I would really apreciate it if you would share it.

 

Thanks

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@TJCappy Try:

= Table.AddColumn(#"Changed Type", "Custom", each Text.Combine({Date.ToText([Column1], "MM"), Date.ToText([Column1], "dd"), Date.ToText([Column1], "yyyy")}), type text)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@TJCappy Try:

= Table.AddColumn(#"Changed Type", "Custom", each Text.Combine({Date.ToText([Column1], "MM"), Date.ToText([Column1], "dd"), Date.ToText([Column1], "yyyy")}), type text)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks @Greg_Deckler , worked like a charm

@TJCappy FYI, I used Add Columns from Examples to come up with that formula.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors