Adding time in Query Editor

[anongard]

Hey all,

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. 

Thanks,

Alex

[Vvelarde · Accepted solution]

@anongard

Hi, In a New Custom Column:

=Date.AddMonths([DateField],1)

Regards

Victor

Lima - Peru

[anongard]

Perfect! Thank you so much. Is there a list of commands like this that can be used in Query Editor? I haven't found a good repository that is clear like that. 

[Vvelarde]

@anongard

You can see this in:

https://msdn.microsoft.com/en-us/library/mt296606.aspx