Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
I hope you can help me here. I 've got a column which is called document_field2 which has dates in it as text.
e.g.
80624
170624
Now I try to get these dates using following:
= Table.AddColumn(#"Gefilterte Zeilen", "Date", each Date.FromText([document_field2], [Format="dMMyy"]), type date)
It does work for lines which has 6 digits (like 170624) but not for lines with 5 digits (like 80624). Do you know how to solve this?
Best regards
Solved! Go to Solution.
And if instead you specify a culture, like so:
= Table.AddColumn(#"Gefilterte Zeilen", "Date", each Date.FromText([document_field2], [Culture="en-GB"]), type date)
This converted all dates without issue for me.
I hope this is helpful
I've found another solution.
I added a custom column using:
=Text.PadStart(Text.From([document_field2]), 6, "0")
This will add an extra 0 in front when it has not 6 digits.
After that the Date column is working right.
And if instead you specify a culture, like so:
= Table.AddColumn(#"Gefilterte Zeilen", "Date", each Date.FromText([document_field2], [Culture="en-GB"]), type date)
This converted all dates without issue for me.
I hope this is helpful
Hi m-dekorte,
Unfortuneately, there is no change in the result using Format="%dMMyy".
I had look on this article before and tried several things but didn't work either.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.