Forum Discussion
Calculating contracts to expire
Folks,
I have a car rental table with contract closure dates. I need to know which contracts will win in the next 3 and 6 months.
The logic I set is not working, can you help me please?
Measure = VAR INICIO = MONTH (TODAY ()) + 1
VAR FIM = INICIO + 2
Return
CALCULATE(
[Ativo];MONTH(FROTA[MÊS_PREV_CALC])>=Inicio && MONTH(FROTA[MÊS_PREV_CALC]<=FIM);YEAR(FROTA[DT_PREV_CALC])=2019)
No Replies