Forum Discussion
Problem on create date column
Hi, my raw data does not have a date date type column. It only label the excel sheets with quarter-year. After imported all 4 sheets of excel I created 2 new calculated column to fill up all row with...
Anonymous
Thanks for the reply.
The Quarter and Year are the columns that I added in Power Query. The original data do not have these 2 columns. It is a label on the original data. Here is how it looks like.
alvin199 again, what is the date you are actually trying to represent? The start of the quarter? The end of the quarter? Some random date in the middle of the quarter?
Anonymous
The dataset has labelled Quarter 1 2021 until Quarter 4 2021 but it does not have a column putting Quarter and year and date type data. So, I created two calculated columns, namely Quarter (for 1 to 4) and Year (2021). The data type is text. If I change to date or date/time data type, it will give out Error in Power Query.