Date

[Anonymous]

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. Thanks in advance  for your upcoming solution

Here is the date but it is in decimal number but when i try to change it to date format it is giving me something else as shown below;

[Anonymous]

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]

@Anonymous it is not working. Can you please tell me where should i paste your Code? I am new in Power bi

[wdx223_Daniel]

=Table.TransformColumns(PreviousStepName,{"GJ",each #date(2022,12,_)})

[Anonymous]

@wdx223_Daniel your solution is not working or may be i am doing it wrongly

[wdx223_Daniel]

replace PreviousStepName with your real step name, which is listed on the right pane 

[Anonymous]

@wdx223_Daniel I am really not clear please

[Anonymous]

@wdx223_Daniel should i create a new colum and add this Syntax?