Forum Discussion
Solved
Cannot change data type text to date ,It error
I have raw data ,Format on Excel and Qlikview is date ,but the same format on Power BI is text .when I chang data type text to date it error
Hi,
One of ways to solve this is, in two steps, to change the data type to Date/Time data type, and then change it to Date data type.
Or, in one step, please try to write M code something like below.
Jihwan_Kim
Super User
Super UserHi,
One of ways to solve this is, in two steps, to change the data type to Date/Time data type, and then change it to Date data type.
Or, in one step, please try to write M code something like below.