Forum Discussion
Converting Quarter & Year to Date
Hi all,
I have a quarter & year column in my date table and am getting an error message when i try to convert it to a date, i have checked in the query editor and quarter & year is marked as a date field.
Just wondering if i am missing something obvious?
Thanks
Do you know how to sort a column by another column?
7 Replies
- mangaus1111
Solution Sage
Hi Anonymous ,
can you send a screenshot of your date table?
- mangaus1111
Hi Anonymous ,
I don´t understand why you need to convert the [Quarter & Year] column from text to date. Normally in the date table only the column [Date] must be in date format.
Are you sure that the [Quarter & Year] column in Power Query is in date format? Do you have a screenshot of it?
- mangaus1111
Hi Anonymous ,
you have already in your date table this column in whole number format that can help you to sort the column [Quarter & Year] in your visual.
- mangaus1111
Do you know how to sort a column by another column?