Excel BI Challenge Workout 031

Workouts Excel BI Challenge
1

— CAN YOU SOLVE THIS - EXCEL CHALLENGE 31 —
(Power Query solutions also welcome for Excel Challenges)

Provide a formula to calculate the Sum of Revenue quarter-wise (Year part needs to be ignored).
Quarters are calendar quarters i.e. Jan-Mar: Q1…Oct-Dec:Q4

(Post answers in Comment. Your formula need not be different from others as long as you have worked out your formula independently)

Download Practice File - https://lnkd.in/dqn3w_D7

#excel, #challenge, #advancedexcel, #excelchallenge, #excelproblem, #excelquestion, #excelsolution, #excelformulas, #excelfunctions, #exceltips, #exceltricks, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #M, #powerpivot

image
image1040×617 87.2 KB

Excel BI’s LinkedIn Post:

4 
=LET(d,A2:A20,r,B2:B20,
qtr,CEILING.MATH(MONTH(d)/3),
_uq,UNIQUE(qtr),
_o,HSTACK("Q"&_uq,MAP(_uq,LAMBDA(x,SUM(FILTER(r,qtr=x))))),
VSTACK({"Quarter","Revenue"},_o))

Quarterly Revenue - Quadri Atharu.xlsx (24.4 KB)