Forum Discussion
How to select current quarter
I have a table with 2 columns for start and end date that have the start and end quarter date
| Customer | goal | start date | end date |
| 123 | 2 | 01/01/2024 | 01/03/2024 |
| 456 | 3 | 01/10/2024 | 01/12/2024 |
| 789 | 2 | 01/01/2025 | 01/03/2025 |
| 456 | 2 | 01/01/2025 | 01/03/2025 |
is there a way to automatically select the current quarter?
TIA
Anonymous
you can try this to create a column
Column = "Q"&QUARTER('Table'[start date])&" " & year('Table'[start date])
3 Replies
Anonymous
what do you mean by select the current quarter?
I didn't see any date related to current quarter in your sample data.
could you pls elaborate more on this? what's the expected output based on the sample data you provided
yes, so the data is not formally correct but that's how it is, so
Customer goal start date end date Customer goal start date end date WHAT IT MEANS 123 2 01/01/2024 01/03/2024 123 2 01/01/2024 01/03/2024 Q1 2024 456 3 01/10/2024 01/12/2024 456 3 01/10/2024 01/12/2024 Q4 2024 789 2 01/01/2025 01/03/2025 789 2 01/01/2025 01/03/2025 Q1 2025 456 2 01/01/2025 01/03/2025 456 2 01/01/2025 01/03/2025 Q1 2025 The dates are always in that strange format, but they do point to a specific year/quarter.
I would like either to select the current quarter during import
TIA
Anonymous
you can try this to create a column
Column = "Q"&QUARTER('Table'[start date])&" " & year('Table'[start date])