Forum Discussion
Power Query - How to Format Date Column to Specific Format?
rodneyc8063_1 , Any specific need to format in power query. Because you have format option if power bi column tools for display purpose, outside power query, you can use that.
amitchandak- Thats a good question
So to be honest I am not an every day user of PBI and only help out when I am asked to, so I am still slowly learning the tool.
I do realize, as you pointed out that in the display portion of PBI Desktop that it is very easy to just simply change the date format. Thats why I was just "curious" and "assumed" that some similar easy functionality would be in Power Query as well.
I guess one of my concerns is consistency. As in the future once this dataset is built out, I am assuming a number of other users could use the same data set for different reports. So I just wanted to make sure that the data is properly formatted and set, before letting folks come in and start using the data set as is.
I guess its not a huge concern as users can still format it in their report themselves, but it would just be nice to have everything set up from the get go