Forum Discussion
Power Query - Group by Quarter (Middle of)
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.
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.