Days Between Two Dates in Power Query M

Notes

Both columns must be type date (or datetime) for the subtraction to produce a duration.

Requirements

• A table with two date columns.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Relative Date Labels (Today, Yesterday, Last 7 Days)Adds a text column that labels each date relative to today, such as Today, Yesterday or Last 7 Days.
• Business Days Between Two DatesCalculates the number of weekdays (Monday-Friday) between two dates, excluding weekends.
• Month-Year Sort Column (e.g., 2026-03)Adds a sortable text column combining year and month so month names sort chronologically instead of alphabetically.
• Week Start and Week End DatesAdds columns for the Monday (week start) and Sunday (week end) of the week each date falls in.
• Convert Excel Serial Number to DateConverts an Excel date serial number (like 45000) stored as a number into a real Date value.
• Date from Year-Month TextConverts a YYYY-MM text value into the first day of that month as a real Date.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Days Between Two Dates.