Text Quarter format to Date Quarter

[bnag]

Hi All,

My data has quarter values in text format (example - JAN-MAR, APR-JUNE). I want to change it to the proper Quarter Date format in Power query. 

Please help.

[v-zhangti]

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.