Forum Discussion
Date Format Conversion
You can use "Add Column from Examples" option to enter the format you require in one or two records. It will detect automatically the required expected format and will populate for all other rows as well. Then replace the old column with new column.
That's cleaner than my solution since you can delete the old column.
Pat,
This approach is useful, but since my data is large is there a way to do this without adding a new column and changing the existing column( such as how we change the format through modelling)as this might cause performance issues. Plus since this is a date field i would prefer it to remain the same as there are dependencies based on this column.
Thanks
Aj
Hi ajin,
Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in Ideas forum. You may submit a feature request on idea.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
Hi ajin,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
