Solved: Re: Datumsspalte lässt sich nicht formatieren

Anonymous · ‎04-07-2022

Guten Tag,

wir haben eine Datumsspalte im Format ddmmyyyy (Beispiel: 07042022).

Diese Zahlenfolge lässt sich nicht in ein valides Datumsformat konvertieren.

Gibt es eine Möglichkeit?

vielen Dank

amitchandak · ‎04-07-2022

@Anonymous , create a new column

Date = date(right([column],4), mid([column],3,2]), left([column],2) )

similar functions in power query too

Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎04-07-2022

@Anonymous , create a new column

Date = date(right([column],4), mid([column],3,2]), left([column],2) )

similar functions in power query too

Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Datumsspalte lässt sich nicht formatieren

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024