Excel Power Query Last month to date

[gazmoz17]

Hi,

Really struggling with this to find any help on the web.

Have a current query which is "Last Month data"
Wish to dupe this query and change it to last month to date. End game being I can ref this alongside "Current Month" query so I have month to date versus last month to date etc.

So new query "Last MTD" would run (based on today) 01/09/23-26/09/23

Many Thanks

 

[gazmoz17]

I thought this would be pretty simple being what most businesses look at.

This is what Im looking to do:

-- unavailable video removed --

But I dont use Power BI, is this possible in the excel power query?

Many Thanks

 

[smozgur]

The video you posted is not available to public. Therefore, it has been removed.

I suggest posting a sample data set with your query, and desired result. It would be more helpful to help to solve your question.

 

[GraH]

You can create a variable, which you use in a filter statement.
The var would be like

Date.StartOfMonth(Date.AddMonths(Date. From(DateTime. LocalNow()), -1))

The filter is then Date>= parameter.