Need help with a DAX measure that will calculate the hours spent on a task in a percentage

[_isildur]

Hi Community,

I have tried to get my head around how to create a measure to calculate the following:

I want to create some sort of linear appreciation depending on how many hours a consultant spent on a task.

I have a startdate and an enddate for the specific task related for a project. I also have how many hours are allocated for the task and how many days are there from the startdate to enddate.
Ex.

Project name	Task name	Startdate	Enddate	Allocated Hours	Datediff	Avg Hours pr. day
Project X	Task 1	01-11-2021	11-11-2021	25	10	2,5
Project X	Task 2	02-11-2021	15-11-2021	10	13	0,75

If the todays date is greater than the enddate, then the task completeness should be 100%. If the enddate is greater than todays date, then I want the measure to show how many percentage of the allocated hours has been spent.

[v-easonf-msft]

Hi, @_isildur 

If I understand correctly, the percentage of the allocated hours spent should be equal to the percentage of the allocated days spent right? 

Divide (Today-Startdate,Datediff)

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@_isildur , refer if this blog can help

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...

You need add today's logic