Forum Discussion
ajin
7 years agoHelper II
Date Format Conversion
Hi guys, I have dates in the format of dd-mmm-yy(01-Apr-17), is it possible to convert it to dd-mmm-yyyy(01-Apr-2017) ? Thanks Ajin
ajin
7 years agoHelper II
Hi Guys,
Both the methods mentioned here involves adding a new column. The reports that I'm working with have huge data, hence I think adding new columns for all date fields might cause performance issues , therefore is there any alternative method of directly changing the column format without adding a new column ?
v-danhe-msft
7 years agoMicrosoft Employee
Hi ajin,
Based on my research, I am afraid you could not modify the row data in Power BI, I still suggest you to use the Format function to achieve your result.
Regards,
Daniel He