I have a date column in Power Query with the following format: 3/1/2021. I am trying to convert it to this format: 20210301. I can split out the columns into three columns and merge them back together in the format I want but when I do I get this: 202131 instead of 20210301. It is dropping the zeroes. I just tried inserting a "Column From Example" and it worked. However, the column must be formatted as text and not a date. Any suggestions?
Power Query supports "system" data formats based on data type and locale defined in Power Query settings or by culture parameter where available. There are no custom formats as in Excel grid or in data model since data in Power Query that's not what you show to end user.