topic compare dates in App Development

compare dates

RSltz — Mon, 20 Dec 2021 21:08:46 GMT

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

Re: compare dates

Saravanan_Desingh — Fri, 19 Jun 2020 23:41:06 GMT

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

Re: compare dates

RSltz — Sat, 20 Jun 2020 18:34:50 GMT

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.