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

Today is the 29th of July 2021... this Power Query M returns 1st of June 2021 like `1/06/2021`

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

m power-query

← Back to the Posts

let
    Source = Date.StartOfMonth(Date.From(Date.AddMonths(DateTime.LocalNow(),-1)))	
in
    Source

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

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

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

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

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

Add a DateKey Column in PowerBI M Lang

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