Forum Discussion
Return Date field from Text
MID is a function that pulls part of a text string. (7,4) tells the engine to start at the 7th character and get 4 characters which returns '2020'
Yes. That's the great thing about Power BI. Your data transformation steps and DAX expressions (columns) are saved and re-applied at each refresh.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi Anonymous ,
1. Use Dax.
2. Use M query.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft EmployeeThis is much easier to do in the query editor. Just highlight this column and choose Extract on the Transform tab, then Text Before Delimiter. Enter a space and hit ok. Then change to Date format.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
The data will be dynamically replaced. Hence, after applying the your suggested steps. Subsequent attempt, when I upload new data. The steps, which we performed were getting wiped out.
Hence, I preferred to move the data to the REPORT tab and apply the logic I want to.
Please suggest if you have any better option to retain the settings, even after uploading new data every time or syntax to fix my requirement.
- mahoneypat
Not sure what you mean, All of the data will be reprocessed at each refresh (both the query and the calculated column suggestions). The steps remain in the query. Can you clarify?
Regards,
Pat
The data I feed in Query editor, will be replaced on a daily basis. I am importing fresh data frequently in the same input sheet.
In that case, will the suggested steps to change the format be retained?