Forum Discussion

Charlieb's avatar
Charlieb
Regular Visitor
2 years ago
Solved

Extract date from text - very difficult

Hi,   As suggested here, rather than reading from a live .csv to obtain data, I am connected to a folder which will read a dated file, created each day.   Lets assume the filename is 'file_name_2...
Need Help
  • Sullyball2a's avatar
    Sullyball2a
    2 years ago
    Using the following as a calculated column in Power BI Desktop should work
    = DATE(MID(test[Source.Name],24,4),MID(test[Source.Name],21,2),MID(test[Source.Name],18,2))
    ...but you are much better doing this as an additional column from examples in Power Query
Sullyball2a's avatar
Sullyball2a
Frequent Visitor
2 years ago
Using the following as a calculated column in Power BI Desktop should work
= DATE(MID(test[Source.Name],24,4),MID(test[Source.Name],21,2),MID(test[Source.Name],18,2))
...but you are much better doing this as an additional column from examples in Power Query
Charlieb's avatar
Charlieb
Regular Visitor
2 years ago

Thanks, that worked. I'm not sure if Power Query is a thing in the online version of PowerBI?