cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anongard
Helper I
Helper I

Adding time in Query Editor

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

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@anongard

 

Hi, In a New Custom Column:

 

=Date.AddMonths([DateField],1)

 

Regards

 

Victor

Lima - Peru




Lima - Peru

View solution in original post

3 REPLIES 3
Vvelarde
Community Champion
Community Champion

@anongard

 

Hi, In a New Custom Column:

 

=Date.AddMonths([DateField],1)

 

Regards

 

Victor

Lima - Peru




Lima - Peru

View solution in original post

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
Community Champion
Community Champion

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.