Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Numbersequence is not recognized as date

Hi all,

i have following issue. 

I have this column from a DWH. Unfortunately PowerBI doesnt give me the desired transformation from numbers to date...

Enddatum means end date after editing from number to date

 

any ideas?

 

Help is much appreciated...

 

thanks in advance

 

BR,

Paul

 

Need Help
Tips and Tricks
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi Anonymous,

    your Enddatum must be first set to text type, then to date type.

     

    Regards FrankAT

     

4 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion
    6 years ago

    Hi Anonymous,

    your Enddatum must be first set to text type, then to date type.

     

    Regards FrankAT

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thank you all.

      FrankAT very smooth solution

       

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi Anonymous 

    in the query editor try :

     

    Date.From( Text.From( [Enddatum] ) )

     

     

     

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Seem like if did not recognize as date . You can create a new date column like

    date = date(year(left([Col],4)),month(mid([Col],5,2)),day(right([Col],2)))