Forum Discussion

ok_kpop's avatar
ok_kpop
Frequent Visitor
2 years ago

Text to Date Formula Help

Every month I load in an excel file into my Power BI template. The spreadsheet has a column formatted as text which represents the date and looks something like "80123" which represents August 1, 202...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this

Date.FromText( Text.PadStart(Text.From(
    [date]),6,"0"), [Format = "MMddyy"])