I'm having a hard time figuring out how to add one month to every date in a column using power query or M syntax. I can easily add time using DAX in data view, but in order to do a Group By to create a pivot-tablesque solution I need to do this in the Query Editor, or so I think. Is there any simple way to do this?
I have gathered from previous threads that it has something to do with the #duration function, but I don't actually know how to apply that. Any help would be appreciated.