Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
May 08, 2021
Solved

Power Query - Group by Quarter (Middle of)

Hello,   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 o...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    May 10, 2021

    Tony2021 

    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.

ExcelExciting's avatar
ExcelExciting
MVP
May 09, 2021

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.

Resources