How to select current quarter

[df123445]

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 

[ryan_mayu]

@df123445 

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

[df123445]

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 

[ryan_mayu · Accepted solution]

@df123445 

you can try this to create a column

Column = "Q"&QUARTER('Table'[start date])&" " & year('Table'[start date])