Forum Discussion

alvin199's avatar
alvin199
Icon for Helper III rankHelper III
4 years ago

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...
Need Help
Aburar_123's avatar
Aburar_123
Icon for Solution Supplier rankSolution Supplier
4 years ago

you can not convert the quarter value or an year value to a date. if you want to have a date value then you can do like below,

 

Assume you have already having two calculated columns/Custom columns created in Power query as like Qtr and Year. So your date column would be like below,

 

Date = Date(Year,Qtr,1)