Forum Discussion
Solved
Power BI Text to Date conversion - Extreme newbie
Hi All, I have tried my best to figure this out (many hours), read many pages and I still cannot get this right, please could I get some help. I am new to Power BI. I want to convert the orgi...
The lowest form of data I have on the origial data is "2024 Q1"Add a Date column to your data, for example the first day of that quarter. Use the Date column to join to the calendar table.
In your data model include a calendar table. Mark it as a Date table. Use the standard Time Intelligence functions. No need to do any string math contortions.
Thank you for the reply - the issue I feel I have (or maybe not understanding), is linking the original data to the calendar table.
i.e. The lowest form of data I have on the origial data is "2024 Q1". How I create the logic to convert this to a usable date is causing the problem.
The lowest form of data I have on the origial data is "2024 Q1"Add a Date column to your data, for example the first day of that quarter. Use the Date column to join to the calendar table.
