Power Query - Group by Quarter (Middle of)

Frequent Contributor



I have a power query and I have dates and need to know if its possible to group by the middle of the quarter within power query?  I see grouping is possible but in Transform Data but the only options for the date column is beginning of quarter or end and I do not see "middle".  


maybe there is a creative way to do this?  


thank you

2 Replies

Hi @Tony2021 


Could you please attach sample data with your desired results showing it manually 


Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

best response confirmed by Tony2021 (Frequent Contributor)


There is no built-in transformation on middle of the quarter. You may do it yourself by adding custom column with it, if only you define what the middle of the quarter is. Quarters have different number of days, for Q1 it also depends that's leap year or not. You may add 45 days to the beginning of quarter, or add to the start of quarter (end - start +1)/2, the only is to decide to round up or down if quarter has odd number of days.

Having such column you may use it for grouping.