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...     any ideas?   Help is much ap...
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

     

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)))