Pro Rated Value based on Days of Month - Formula Help

AndrewUrban — Wed, 01 Feb 2023 16:58:42 GMT

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!

Re: Pro Rated Value based on Days of Month - Formula Help

Anonymous — Thu, 02 Feb 2023 01:32:31 GMT

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])

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.