Incoherent summary when period is quarters, year or even YTD
I'm really at the beginning of the journey of being Model Builder so I'm afraid that what I'm to ask you is really basic, but hope to find help and the learn more .
The context of the issue is that the following line item is looking for the customers that have 0 revenue in the current month, and if is true, then it shows the revenue from the previous month.
Month by month it is coherent, but when the period is a quarter, FY or even YTD, it explodes and so far from the reality.
I've tried multiple combinations of summaries, but no luck until now, to discover how to adjust the formulas, in order to simply add the monthly amounts and not check if the condition is met.
Thank you !