PowerQuery last 8 weeks

[Anonymous]

Hi guys. I'm trying to figure out how to get the last 8 weeks with PowerQuery. I'm getting the data from our CosmosDB.  I'm getting to much data at this moment then I actually need and it's taking very long to refresh..

I'm have little experience with PowerQuery and can't seem to understand how to do this. 

Thanks in advance. 

[v-yuta-msft · Accepted solution]

@Anonymous ,

Generally, you can use List.Max to achieve the last date in the date column:

List.Max(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any

 Then use Date.AddWeeks to achieve the previous 8 weeks date:

Date.AddWeeks(dateTime, weeks as number) 

 Finally, filter the date between current week and 8 weeks before.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.