Date.ToRecord is a Power Query M function that returns a record containing the parts of the given date value.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Date.ToRecord( date as date ) as record
Returns a record containing the parts of the given date value,
datevalue for from which the record of its parts is to be calculated.
#date( 2011, 12, 31 ) value into a record containing parts from the date value.
Date.ToRecord( #date( 2011, 12, 31 ) ) /* Output: [ Year = 2011, Month = 12, Day = 31 ] */
Other functions related to Date.ToRecord are: