Numbersequence is not recognized as date

[Anonymous]

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

[FrankAT · Accepted solution]

Hi @Anonymous,

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

Regards FrankAT

[Anonymous]

thank you all.

@FrankAT very smooth solution

[amitchandak]

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

[ImkeF]

Hi @Anonymous 

in the query editor try :

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