Forum Discussion
Calculating forecasting values.
Hello all, I have a measure that works all great. The measure takes the deadline of projects and based on this, it calculates the number of working days and multiplying with the hourly rate of t...
Hi Rupak_bi
Thank you for your message. Actually 'sum' won't do the cut I'm afraid.
workingDaysCount is one of the culprits as it'll return an ubnormal count of days in the Grand Total.
Additionally, a sum of rateOfEmployees won't return the accurate number as it depends on how many hours each of the employee will work on each project.
Please find attached the file with some sample data and the measures (mainly interested on "Price")
Many thanks
PS: not sure how i can share sample file and couldn't find anything relevant here: https://community.fabric.microsoft.com/t5/Using-the-Community/tkb-p/fbc_using_the_community