Forum Discussion
Remaining Month
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.
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.