Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

Anonymous  Thank you