Calculating % time lapsed between start and end date

[Anonymous]

I am trying to calculate the % of time lapsed between by start date and end date. I want to use this value to calculate the # of hours for our target hours used. I can find the calculation for excel - but not a direct match to Power BI 

=(DATEDIF(B2,TODAY(),"d")+1)/(DATEDIF(B2,C2,"d")+1)

[HotChilli]

Use the formula you have.

Create a column in your table using the formula.

Substitute the column headings for cell numbers.

DAX has a DATEDIFF. "d" looks like shorthand for DAY.

If it doesn't work straight off, then break the numerator and denominator into separate columns to debug.