Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jbqrn
Helper I
Helper I

Sum a column if is in a range of dates

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!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.