Dataflow to create dynamic date table to End of Current Quarter

[RichHead1821]

Here's what I did for the end date (initially)

Table.TransformColumnTypes(Table.AddColumn(#"Changed column type", "endDate", each Date.AddDays(DateTime.LocalNow(), 30)), {{"endDate", type date}})

I now want the end date to be set to the end of the current quarter... tried a few things, but no joy. I'm convinced it must be easy, but it's escaping me at the moment.

[RichHead1821 · Accepted solution]

Sorted

Table.AddColumn(#"Changed column type", "endDate", each Date.EndOfQuarter(DateTime.LocalNow()), type date)