Fill blanks with linear interpolation

[igonzalezb]

I have a table in Power Bi that looks like this example

Tag	Date	Value
A	Jan-20	12
A	Feb-20
A	Mar-20	14
B	Jan-20
B	Feb-20	10
B	Mar-20
B	Apr-20
B	May-20	15
B	Jun-20
B	Jul-20	16

I would like to fill the blanks with linear interpolation in  a new column. Note that for B Jan-20 no data can be interpolated and it's left as blank.

Tag	Date	Value	New Column
A	Jan-20	12	12
A	Feb-20		13
A	Mar-20	14	14
B	Jan-20
B	Feb-20	10	10
B	Mar-20		11.66
B	Apr-20		13.33
B	May-20	15	15
B	Jun-20		15.5
B	Jul-20	16	16

[Anonymous]

I have the same problem, but the formula given is not working for dates. Can anyone help me?

[V-lianl-msft · Accepted solution]

Hi @igonzalezb ,

Refer to this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Linear-Interpolation/m-p/330712 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@igonzalezb , see if this can help

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Linear-Interpolation-between-dates/m-p/115520...