Calculate Dynamic Run Rate based on number of days

[Anonymous]

Hello All, 

I have a simple report as can be seen below

Budget run rate = Total budget for the month/ # of days 

Actual Run rate = Total actuals / # of days in month 

I am running into an issue with the Actual run rate as i want to compare partially completed months to the partially completed number of days. Currently '# of days in month' is stored in a file which i can use to calculat the bugdet run rate 

to calculate the actual run rate i am checking whether the month is current if so divide by the(numer of days -calculated measure) otherwise use the run rate actual based on the completed month 

if([MaxMonth]= [Current Month], sumx(table1[Actuals])/SUMX(table,[#ofdays]), McaProdJournalRoute[Run Rate - Actual 2])

When i bring the fields down for the partial month i see the number of days and i see the total actuals but the calculation is not correct 

Measure2 is my calculatedfield based on the logic above (however it is showing up the same as total Tons (Actuals)

[Anonymous]

Sorr, @Anonymous, but the description of the problem is hard to understand. Could you please create a better description? Maybe instead of cramming figures over figures into a picture... it would make more sense to focus on the issue and very clearly pinpoint it with a simple picture?

Best
D

[vivran22]

Hello @Anonymous,

How are these two tables related? What is the calculation for Tons?

Can you share the sample data file for this?

Cheers!
Vivek

https://www.vivran.in/
Connect on LinkedIn