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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors