I have a column currently that is numeric data type as 1's, 2's, 3's and 4's. These actually represent Quarters 1,2,3 and 4 from 2017. How can I convert the column to be recognized as Quarter date.
Go to Solution.
using DAX you can create a calculated column like so (assuming that the column in your table is called "QuarterNo"):
QuarterDate = DATE(2017 , '<tablename>'[QuarterNo] * 3 , 1)
This will create a date that represents the 1st Day of the last month in a quarter.
Of course you can also use EOMONTH(DATE( ... ) , 0)
Hope this provides you with some ideas.
Yes - this is what I needed! Thanks!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!