jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,895
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
My raw data consists of date, year, qtr, mydata1, mydata2,mydata3 etc from which I currently extract all of the data regardless of time period
what I would like to do is extract data for the current quarter, and also the previous quarter I dont mind if it’s separate sheets
as I want to compare the scores and give a placing update up,down, same
the main problem is how to handle quarters when it is Q1, the easy option as the data is from 2019 to current is have a lookup to find current quarter and choose line before. Saves having to say if Q1 then year-1,Q4
can a power query do a lookup and use cell contents as a criteria in a query
what I would like to do is extract data for the current quarter, and also the previous quarter I dont mind if it’s separate sheets
as I want to compare the scores and give a placing update up,down, same
the main problem is how to handle quarters when it is Q1, the easy option as the data is from 2019 to current is have a lookup to find current quarter and choose line before. Saves having to say if Q1 then year-1,Q4
can a power query do a lookup and use cell contents as a criteria in a query