KPI Linear approximation forecast

[Negral75]

Hey guys !

I'm working on my KPI report and I've come across a problem. I need to create a curve of tasks progression, but I need a reference progression too. I group everything by week, so if you have a 6 weeks tasks, it'll only be to 100% at the end week. What I want is to create a linear approximation of this progression.

For example, if you have that 6 weeks task starting week 24, it would go like :

24 : 0% ; 25 : 17% ; 26; 33% ; 27 : 50% ; 28 : 67%; 29 : 83% ; 30 : 100%

But what I have now it's :

24 to 29 : 0% ; 30:100%

I already calculated the coefficient to make the approximation :

 I have no clue about how to create the approximation I want for all the tasks, I don't manage to apply it to even 1 !

Any help is welcome !

[v-yuezhe-msft]

@Negral75,

Which column is week column in the above screenshot? And what fields do you use to calculate coefficient? Please help to share raw data of the table that can be copied so that we can test and provide you appropriate DAX.

Regards,
Lydia