cancel
Showing results for
Did you mean:
Frequent Visitor

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])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

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])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Announcements

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

Microsoft Business Applications Summit sessions

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

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors