cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frello Frequent Visitor
Frequent Visitor

PowerQuery last 8 weeks

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: PowerQuery last 8 weeks

@Frello ,

 

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.

1 REPLY 1
Community Support Team
Community Support Team

Re: PowerQuery last 8 weeks

@Frello ,

 

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.