Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MustafaP
Frequent Visitor

Merge Two dates withf formatting

Hello,

 

I am trying to merge 2 dates into one Column as below, 

 

I have week start date and week end date and i would like to create week order as example;

 

Week SD       Week ED      Week Order

01.01.2024   07.01.2024    01.01.2004 - 07.01.2024

 

Screenshot_9.jpg

 

I triend many possibilites but now as i need result.

 

Screenshot_10.jpg

and formatting not as i wanted.

 

Need to : 01.01.2004 - 07.01.2024

 

thank you

 

1 ACCEPTED SOLUTION
v-binbinyu-msft
Community Support
Community Support

Hi @MustafaP ,

Please try to create new column with below M code in Power Query pane:

= Text.From([Week SD], "en-US") & " - " & Text.From([Week ED], "en-US")

 

Please replace '[Week SD]'  and '[Week ED]'  with the actual column names of your week start date and week end date. This formula assumes your dates are already in the desired format. If not, you might need to format them first using the 'DateTime.ToText'  function with a custom format string, like so:

= DateTime.ToText([Week SD], "dd.MM.yyyy") & " - " & DateTime.ToText([Week ED], "dd.MM.yyyy")

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
v-binbinyu-msft
Community Support
Community Support

Hi @MustafaP ,

Please try to create new column with below M code in Power Query pane:

= Text.From([Week SD], "en-US") & " - " & Text.From([Week ED], "en-US")

 

Please replace '[Week SD]'  and '[Week ED]'  with the actual column names of your week start date and week end date. This formula assumes your dates are already in the desired format. If not, you might need to format them first using the 'DateTime.ToText'  function with a custom format string, like so:

= DateTime.ToText([Week SD], "dd.MM.yyyy") & " - " & DateTime.ToText([Week ED], "dd.MM.yyyy")

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

MustafaP
Frequent Visitor

here it is => https://file.io/let8lOHeixni 

Ritaf1983_0-1706883804402.png

 

Ritaf1983
Super User
Super User

Hi @MustafaP 
Can you please share a link to a dummy file with an example? 

(without sensitive data)

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.