Pro Rated Value based on Days of Month - Formula Help

[AndrewUrban]

Hello! 

I'm looking for a DAX formula that will give me a pro rated value based on the current day in the month.

For example, February is forecasted at $100K, if we are 7 days into the month, I need the pro-rated forecast number which would be $25K. 

Thank you so much! 

[Anonymous · Accepted solution]

Hi @AndrewUrban ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a measure.

Measure = 
var _maxday=DAY(EOMONTH(MAX(Sheet1[date]),0))
return 
(DAY(TODAY())/_maxday)*MAX(Sheet1[forecast])

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.