Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Calculate Dynamic Run Rate based on number of days

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)

 

 

 

snip.PNG

2 REPLIES 2
Anonymous
Not applicable

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
Community Champion
Community Champion

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.