Forum Discussion
Text Quarter format to Date Quarter
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.
1 Reply
v-zhangtiCommunity Support
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.