Sum a column if is in a range of dates

[jbqrn]

Hi everyone,

I am trying to sum a column ([Base_Sup_Total_(M2)]) according to a range of dates.
- Beginning Date [Inicio contrato]
- Ending Date [POC_vcto]

I am trying to do a CALCULATE formula but I am not achieveing it...

Sum if the row is in the year 2022 (for example)

This formula is the one I am using as a counter of the contracts that are active in a date (I want to sum now the m2 for the active contracts)
FORMULA =  

VAR FechaComparacion = LASTDATE(DIM_fechas[Fecha]) //Date table

RETURN

CALCULATE(COUNTROWS(O_Cond_max_min), //nº contracts

O_Cond_max_min[Inicio contrato]<=FechaComparacion, // BEG DATE <=Active contracts

O_Cond_max_min[POC_vcto]>=FechaComparacion // END DATE >=Innactive contracts
)

Any idea?
Thanks in advance!

[amitchandak · Accepted solution]

@jbqrn , refer to my Blog almost  similar topics, see if that can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...