Forum Discussion
PBIBeginner2022
4 years agoHelper III
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...
jennratten
4 years agoSuper User
Hello again - the solution above creates a table that matches your post "I want this in Power Query". If you are wanting something different, can you please describe the expected results?
PBIBeginner2022
4 years agoHelper III
I have table with lots of column like "Extract_ Month bis". I want added a new column called "Extract_month -6" with the same result that I send you above.
- jennratten4 years agoSuper User
Hello - the result you are requesting matches the outcome of the solution provided. I have shown them side-by-side below.