cancel
Showing results for
Did you mean:
New Member

## Sum on different date

Hi all,

I have two table :

The 1st with my societe_Id , the cost and the cost date

 Id Cost Date 187 125000 01/01/2019 187 255000 01/02/2020 186 255000 01/01/2021 187 155000 21/01/2021

the 2nd with a périod

 Id start date end date 187 01/01/20 31/12/20 186 01/07/20 31/06/20

I want to calculate the sum of each cost between the date of the 2nd table.
I don't find how to, could someone help me ?

1 ACCEPTED SOLUTION
Super User IV

@clmigeon , A new column table 2

new column in Table 2 = sumx(filter(Table1, Table1[ID] = Table2[ID] && Table1[Date] >=Table2[Start Date] && Table1[Date] <= Table2[End DATE]),Table1[Cost])

Proud to be a Super User!

Super User IV

@clmigeon , A new column table 2

new column in Table 2 = sumx(filter(Table1, Table1[ID] = Table2[ID] && Table1[Date] >=Table2[Start Date] && Table1[Date] <= Table2[End DATE]),Table1[Cost])

Proud to be a Super User!

Announcements

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks