Forum Discussion
DavidMoss
Advocate V
Advocate VPower Query M filter data by Dynamic Date (PQ not DAX) Start of Month
More as a reference for us than a question which hopefully you will find useful :-) I was just working on filtering data in Power Query based on the date. I kow you can manually filter your sourc...
MarcelBeug
Community Champion
Community Championdescalabro Power Query has several Date functions to add/subtract periods from dates (can also be used with Date/Times and Date/Time/Zones):
Date.AddDays
Date.AddMonths
Date.AddQuarters
Date.AddWeeks
Date.AddYears
Remark: if the result would be a non existent date (e.g 1 month added to January 31), then'the result will be the last day of the month.
DavidMossAdvocate V
Advocate VFurther Power Query M language or as some call it PQL documentation here
https://msdn.microsoft.com/en-us/library/mt253322.aspx
- ImkeF
Hi DavidMoss, thx for the trust, but you've probably recognized by now, that MarcelBeug is at least on par with me by now ;-)
