Forum Discussion
Power Query M filter data by Dynamic Date (PQ not DAX) Start of Month
descalabro 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.
MarcelBeug, thanks a lot. :)
I'm looking for a way to reduce PBI file size. My PBI file is connected to 8 Access files which I am not able to alter in any way. Is there a way to use this kind of filter right on the loading step, so that only a part of each table is loaded into PBI?
Or perhaps, is there a way to actually delete rows based on the same method as this filter?
I know the filter prevents data from being calculated on the actual report, but still I would like to save time when opening, refreshing and also publishing the file.
Once again, thank you,
TJ