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])
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])