Forum Discussion
Date
I took a date in a Database with the year 18,19,20,21,22 and i load it but it came as decimal but when i try to convert these to Date it comes out as 1900 and i don't know how to get the right date. ...
If you just need the 4 digit year, just click the "Addition" button and add 2000. If you are trying to get a date like 1/1/2019, etc. then try:
= Table.AddColumn(PriorStepOrTableName, "Year", each #date([GJ]+2000, 1, 1), type date)
--Nate
Anonymous it is not working. Can you please tell me where should i paste your Code? I am new in Power bi