required rate and current rate for this month

[Karthik12]

Hello Team,

I would like to visualize the following data in my daily management board.

1. Current rate and 2. Required rate. Both I need to calculate only for current month.

I have following inputs 

1. Plan sheet

2. Actual prod sheet

3. Date sheet

Plan sheet

2. Actual sheet

3. Date 

Is it possible to calculate that?

[Karthik12 · Accepted solution]

@amitchandak 

Thanks for tyour time. I have tried below measure to calculate the Required run rate and it is working fine.

RRR = DIVIDE(('mis monthly_plan'[Plan sum]-[Sum of Actual]),[REMAINING DAYS])

[amitchandak]

@Karthik12 , You join both tables with date table and measure like 

example with net measure

This Month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

[Karthik12]

@amitchandak Thanks for your time.

I have attached the pbix file for your reference.

Kindly support for card visuals indiacating below

Current rate = Total production till yesterday / No of days till yesterday (for the current month)

Required rate = (Sum of plan whole month - total production qty till yesterday)/No of days remaining till end of the month

https://vontier-my.sharepoint.com/:u:/g/personal/karthikeyan_palanisamy_gilbarco_com/EVdko3nH1qxAs1X...

Thanks in advance for the support !