Add a DateKey Column in PowerBI M Lang

Date's can get difficult to merge on other date or datetime fields. Use this function to convert to a DateKey or Date ID

me@jaykilleen.com wrote this over 7 years ago and it was last updated over 7 years ago.

m power-query power-bi

← Back to the Posts


  AddDateKey = Table.AddColumn(LastQueryStep, "DateKey", 
    each 
      Number.ToText(Date.Year([CreatedDate])) &
      Text.PadStart(Number.ToText(Date.Month([CreatedDate])),2,"0") &
      Text.PadStart(Number.ToText(Date.Day([CreatedDate])),2,"0"
    )
  )

Similar

Excel IFERROR in Power Query M or Power BI

[SOLVED] Excel ISNULL, ISBLANK type custom function in Power Query M

Power Query M function to add days to a date

Power Query M Blank Function Template

[SOLVED] First Day of Last Month in Power Query M

Blank Power Query Template for a Raw SQL Query using Microsoft SQL Server

Return Database Schema for Table Using Power Query

Add Text to an Existing Column in Power Query

Power Query - Left Pad an SAP Product Hierarchy with Zero

Extract Multiple Product Hierarchy Levels from an SAP Product Hierarchy Key

Blank Power Query Template for a Raw SQL Query

Removing Leading Zeros from Alphanumberic Strings using Power Query M

Remove Leading Zeros from Strings using Power Query M

Create an Empty Table with Explicit Types in Power Query M

[SOLVED] Today's Date in Power Query M

A Simple Worksheet Parameter Pattern for Power Query

Cross Join in Power Query to Combine Two Tables with Every Combination

Add Dynamic Role Level Security to PowerBI Using an Attribute of the Current User

Add Dynamic Role Level Security to PowerBI using current users email

Using VS Code Extension MSSQL instead of Excel Power Query for Easy Database Querying

Add Hyperlinks to an Entire Column using VBA in Excel

Create a Simple Empty Table in Power Query with Code Example

Add a Date Model to PowerBI or Power Query

Writing a Blog Post About M Lang/M Language/Power Query Formula Language/Power BI/Get & Transform

Connect PowerBI to a Remote PostgreSQL Database Encrypted with SSL

Simple Power Query M to Display When the Report was Last Refreshed

Display a SQL Server Table Schema in PowerBI

Turning On Fast Combine in Power BI to enable Personal Gateway Data Refresh

Creating an Atom Grammar Language Package for M Power Query Formula Language

The Microsoft Mashup Evaluation Container is a CPU and RAM hog

Power Query to Test if Date is between Start and End Dates including Nulls

Tiny Tweaks Needed for the Power Query Editor

Implementing an Environment Parameter in Power BI to Improve Performance in Development

Managing Queries in PowerBI and Power Query using Git

SumIFS in Power BI DAX Using Current Row Value as Filter

CountIF in PowerBI DAX

Loading M Queries from the Web into Power BI

Single and Multi Line Comments in Power Query Advanced Editor

Countif in Power Query or Powerbi using M Language