Forum Discussion
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...
HotChilli
Community Champion
Community ChampionThere will be another formula but why don't you pad the text using :
Text.PadStart(theColumn, 6, "0")and use the 2nd formula on everything.