formatDate

/*
Function: formatDate

Parameters:
dateValue (datetime): The date value to be formatted.

Return Type: text

Description: This function takes a date value and formats it to 'DD-MM-YYYY' format.
*/

let
    formatDate = (dateValue as datetime) as text =>
    
    let
        formattedDate = Text.Combine({Text.PadStart(Text.From(Date.Day(dateValue)), 2, "0"),
                                      "-",
                                      Text.PadStart(Text.From(Date.Month(dateValue)), 2, "0"),
                                      "-",
                                      Text.From(Date.Year(dateValue))}, "")
    in
        formattedDate
in
    formatDate

Usage Example:

Suppose you have a list with a date value, and you want to format each date in the list to 'DD-MM-YYYY' format. You can use the function formatDate as follows:

1. Create a new query and load the list with date values.
2. Add a Custom Column using the "Add Column" tab.
3. Use the formatDate function in the Custom Column formula by referring to the date column.
4. Close & Apply to see the formatted date column.