Remaining Month

[Anonymous]

Hi, I have a measure that lets me know how much time is needed per month. To get this I divide hours to months remaining. However, every month I have to go in and manually change the number. Is there a way to have to automatically update.

Hours needed per month = [Hours to Target]/4

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.

Hours needed per month = [Hours to Target] / DATEDIFF(TODAY(), [Target Date], MONTH)

This formula will calculate the number of months remaining between today's date and the target date, and divide the hours to target by that number. This way, the measure will automatically update as time passes and the target date approaches.

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 _ Rongtie

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

[Anonymous]

@Anonymous  Thank you