@huhuhu wrote:
Hello,
I have a problem to keep ALL data in the most recent quarter for each measure.
Characters in my data;
1. The most recent quarter depends on the measure you select
2. The most recent quarter changes every month for each measure
My data look like:
ID Measure Quarter
1 A Q1 2020
2 A Q2 2020
3 B Q2 20202
4 B Q3 2020
5 B Q3 2020
I like to keep ID 2, 4 and 5, since ID 2 is in the most recent quarter of measure A and ID 4&5 are in the most recent quarter of measure B.
Any advice will be appreciated.
Thank you!
I would suggest that instead of the phrase "most recent" when you describe this data that you use "last quarter". Especially since many of your values as of March 2020, when this question is asked, are actually in the future and hence are not "recent" which typically refers to "up to a date", "of late" , "latest".
So "recent quarter" would more often be either 1) the current calendar quarter or optionally 2) the calendar quarter preceding the current quarter, and which explicitly stated.
... View more
