Forum Discussion
Date formatting
Hi, I have a table (data) like this: I want to use first row as headers. But before that I want to change the date formats in that row as text as it looks (yyyy-mm-dd). It there an easy w...
HI Anonymous
In the Power Query Editor, convert this as data column and split the columns to month, date and Year and rearrange as Year,month and date.
Then select these 3 columns and right click -> select merge option.
Promote the first row to header, the format will be retained.
Thanks
Raj
HI Anonymous
In the Power Query Editor, convert this as data column and split the columns to month, date and Year and rearrange as Year,month and date.
Then select these 3 columns and right click -> select merge option.
Promote the first row to header, the format will be retained.
Thanks
Raj