Current date - Extract (Day From Current_date) + 1

Hi,

This might do it

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Calculated Start of Month" = Table.TransformColumns(#"Changed Type",{{"Date", Date.StartOfMonth, type date}})
in
#"Calculated Start of Month"

Thanks,

PS just realised you said add a column so just duplicate your current date column first 🙂

Hi Anonymous ,

Please open a blank query and paste the code.

let
    Source = Date.StartOfMonth( DateTime.LocalNow() )
in
    Source

And you can also create a measure to get date.

Measure = EOMONTH( TODAY(), -1) + 1

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.