Forum Discussion
Add column with sixth previous month
Hi everyone, I need to add a new custom column with sixth previous month in Power Query. I thinked to use that formula but it don't function : = Table.AddColumn(#"Type modifié", "Extract_mont...
Hi,
Add a new step with the following (amend as per column headers)
= Table.AddColumn(#"Changed Type", "6months", each Date.AddMonths([Date],-6))
Thanks,