Current Production Rate and asking rate

[Karthik12]

Hello Team,

I have production data like below pictures. i,e Month total production plan and Current No of Units produced (MTD).

I need to display Current Production rate and Required production rate of the August month.

Can Anyone can help me to do this via measure? So, I can add card visual and show it in the page.

[Karthik12]

@amitchandak Hi Amit, Is there any solution?

Please help

[Luuky]

Hi @Karthik12,

You can use the calculate function and put in Month = August and Year = 2022 for the filters.(CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])) 

What you can also do is add a filter for months and years on the page so you can switch between them. 

If you mean something complete different with your question can you please further explain. 

Greeting,

Luuk

[Karthik12]

Hi, 

Thanks for your time.

Actually, I need to display Current rate and required rate as card visual as shown in below picture.

If my production is 900 nos, 25 days over means Current rate is (900/25) = 36 nos.

But target is 1100 means there is gap still 300 nos which I need to achieve in next 6 days.

So, required rate is (300/6) = 50 nos

Make this one, I request your help.

[Luuky]

Hi @Karthik12,

Translate it to formulas you are looking for 2 values.

Current rate = Produced / DaysPassedThisMonth

Required rate = (Required-Produced) / DaysLeftThisMonth

Then you want to show both outcomes in a card?

Greetings,

Luuk

[Karthik12]

Yes, I would like to show as a card for both values 

[Luuky]

Should be easy for @amitchandak