Forum Discussion

brwalker's avatar
brwalker
Frequent Visitor
1 year ago
Solved

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)...
  • v-hashadapu's avatar
    1 year ago

    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.