cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maximus Frequent Visitor
Frequent Visitor

Convert Fiscal Quarter from Text to Date

I have a CSV file that I've imported into Power BI and it shows that all the quarter "numbers" under the QuarterNum column are texts and not dates. How do I convert them to a date format?Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Convert Fiscal Quarter from Text to Date

Hi @Maximus

 

For your data, do you know which year this is for?

 

What I would do is if the year was the same is to create a conditional column for each quarter based on the Quarter number.

 

So for example if the year was 2017, then I would create my conditional column as below where it is dd/mm/YYYY

 

if Q1 then "01/01/2017"

else if Q2 then "01/04/2017"

else if Q3 then "01/07/2017"

else if Q4 then "01/10/2017"

else "01/01/2000"


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

1 REPLY 1

Re: Convert Fiscal Quarter from Text to Date

Hi @Maximus

 

For your data, do you know which year this is for?

 

What I would do is if the year was the same is to create a conditional column for each quarter based on the Quarter number.

 

So for example if the year was 2017, then I would create my conditional column as below where it is dd/mm/YYYY

 

if Q1 then "01/01/2017"

else if Q2 then "01/04/2017"

else if Q3 then "01/07/2017"

else if Q4 then "01/10/2017"

else "01/01/2000"


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,281)