Hello all, I want to calculate my quarters into my table measures depending on the selected month into my app, I'm using the next function in for the first Quarter. if(Month > '3',Sum({$< Year={$(=Max(Year))} ,Month = {$(=Month(Date#(Max(Month)-2, 'M'))),$(=Month(Date#(Max(Month)-1, 'M'))),$(=Month(Date#(Max(Month), 'M')))}>} [CantidadVen]), if(Month <='3', Sum({$< Year={$(=Max(Year)-1)} ,Month = {$(=Month(Date#(Max(Month)+10, 'M'))),$(=Month(Date#(Max(Month)+11, 'M')))},Year={$(=Max(Year))},Month = {$(=Month(Date#(Min(Month), 'M')))}>} [CantidadVen]),0 ) ) But this not getting to me the result what im looking for. Someone did calculate Quarters depneding on the selected month before? I will apprecciate alot your help. Regards.
