Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |