-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 45-
(Solution in any language also welcome for Power Query Challenges)
Calculate Running Total for each dealer.
The running total is calculated within a bracket of 3 months only. After 3 months bracket, running total will reset.
For Dealer - 1-Dec-2021 and 20-Jan-2022 are within 3 months bracket. But next date 25-Mar-2022 is not within 3 months of 1-Dec-2021, hence Running Total resets here. Once running total resets, next bracket of 3 months start. Similarly, 2-Aug-22 is beyond 3 months from 25-Mar-22, hence running total will reset here also.
Remember 3 months is not equal to 90 days.
Download Practice File - https://lnkd.in/d8KxcCtK
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge
Excel BI’s LinkedIn Post