Forum Discussion
Forecast Estimated Run-out date
Hello,
I have a report that tracts remaining funds. Each line item has one employee that logs 8-hours per shift, M-F no holidays. Using the employees' hourly rate, how can I calculate (DAX measure) an estimated run-out date based on the last date hours were logged.
Thanks in advance!
Hi brwalker , Thank you for reaching out to the Microsoft Community Forum.
Based on your description, I took some sample data and worked out a solution. Please refer attached .pbix file for reference and share your thoughts.
If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
3 Replies
Ashish_ExcelSolution Supplier
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
v-hashadapuCommunity Support
Hi brwalker , Thank you for reaching out to the Microsoft Community Forum.
Based on your description, I took some sample data and worked out a solution. Please refer attached .pbix file for reference and share your thoughts.
If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.Thank you, v-hashadapu . Getting close. Some of the lines do not calculate. The attached file has the related measures in folder: _____Under Construction_____. As an example, TI05, line 0002.TI05 does not return a value. I appreciate all the help, thank you!
