-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 18-
(Excel formulas also welcome)
List the count of quarters for only those rows where Out Quarter > In Quarter.
Out Quarter will not be counted in qualifying rows.
Hence for Y2022Q1 - Y2022Q4, Out Quarter > In Quarter, hence Y2022Q1, Y2022Q2 and Y2022Q3 will be counted. But, Y2022Q4 will not be counted.
Y2022Q2-Y2022Q2 will not be considered as Out Quarter not > In Quarter
Download Practice File - https://lnkd.in/dvxj7pCY
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks, #excel, #excelchallenge, #excelproblem, #powerpivot
Excel BI’s LinkedIn Post