Text Quarter format to Date Quarter

Hi, bnag 

You can try the following methods. First, in the power query:

Column:

Date Quarter = 
FORMAT(DATEVALUE(YEAR(TODAY())&"/"&[Quarter.1]&"/"&"1"),"yyyy \Qq")

Is this the result you expect?

FORMAT function (DAX) - DAX | Microsoft Learn

Solved: Convert month text into date - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.