Forum Discussion

henrys1995's avatar
henrys1995
Regular Visitor
2 years ago
Solved

Difference in Months - Columns

Hi all,   How can Power Query give the below required output:   Source Data:   Employee ID             Employee Name               Start Date                End Date 2321                      ...
Need Help
Show and Tell
Tutorial Requests
  • jennratten's avatar
    jennratten
    2 years ago

    Hi henrys1995 - yes, absolutely.  You can modify this part of the script to customize the format of the date.

     

henrys1995's avatar
henrys1995
Regular Visitor
2 years ago

jennratten thanks - is it possible have instead of MMMyy - have the first of each month so 01/01/24 as a date

jennratten's avatar
jennratten
Super User
2 years ago

Hi henrys1995 - yes, absolutely.  You can modify this part of the script to customize the format of the date.