Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
108
Views
Topic starter
I need to Create a Calendar Table with quarters expressed as Q1, Q2 etc (not numbers 1,2, etc) so I need to pre-pend "Q" to the quarter generation function under Dates and in the process set it to Text format.
I also want to create Half Years (H1 or H2) by the same process but there is no half-year function in Dates.
Any suggestions?
Thanks in advance,
Peter
Posted : 11/01/2021 4:01 pm
Hi Peter,
While you have the numeric quarters, you can add a column with a simple formula:
=if [Quarter]<3 then "H1" else "H2"
Now, you can transform the quarter column, simply add the "Q" prefix (Transform>Format>Add Prefix)
Posted : 12/01/2021 4:15 pm
