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/1...
Anonymous
you can try this to create a column
Column = "Q"&QUARTER('Table'[start date])&" " & year('Table'[start date])
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])