Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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. 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;

 

7 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

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

    • Anonymous's avatar
      Anonymous
      Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not applicable

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

      • wdx223_Daniel's avatar
        wdx223_Daniel
        Community Champion

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

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