cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maureen Regular Visitor
Regular Visitor

Quarter format

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Quarter format

Hey,

 

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.

 

Regards,

Tom

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
2 REPLIES 2
Super User
Super User

Re: Quarter format

Hey,

 

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.

 

Regards,

Tom

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Maureen Regular Visitor
Regular Visitor

Re: Quarter format

Yes - this is what I needed!  Thanks!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 228 members 2,719 guests
Please welcome our newest community members: