compare dates

[RSltz]

Hello

to simplify my problem, i have  time resolved production numbers stored in one table like this

Date | Production Number

Jan | 12

Feb | 7

Mar | 17

....

In a second table, linked via the date field, i have Measures leading to savings that can be made from this date:

Date | Measure  | Savings

Feb | Measure 1 | 100,00 €

Mar | Measure 2 | 50,00 €

No i'd like calculate how many part are effected by the measures and how large the  savings are
(No of Parts * Saving per part)  As result I expect :

Measure       Concerned Parts   Sum Savings

Measure 1    24 (7+17)                   2400   (24*100)

Measure 2    17                                   850   (17*50)

i dont how to form a set analysis like
sum({<Date={">=$(Date)}>}[Production Number]) or

sum({<Date={">=$(Date)}>}[Production Number] * [Savings]).

Do you have any suggestions  or can you help me ?

Best regrads

[Saravanan_Desingh]

Can you explain me how the Measure get 7+17? It has only Feb. So it should get only 7 right?

[RSltz]

That is exactly the issue.  Measure1 is performed in Febuary and Measure1 concerns the the parts produced in Febuary   -> or  later <- !!!!!.

So savings were generated in February and March by Measure1,    and in Febuary 7 parts are produced and in March 17 parts are produced. In Febuary 7 * 100,00 € is saved by Measure1 ,  in March 17 * 100,00 is saved by Measure1.

So the savings, achieved by Measure1 is 24 * 100, 00 €

Measure2 is performed in March, so only the production in March is affected by Measure 2.

Perhaps I should have presented the example for a longer period. If i had specified production numbers also for April, May, ..,  you would  have seen, that these month should by affected by Measure1 and Measure2 and savings are generated in these further month by both Measures.