Forum Discussion
Solved
Fill blanks with linear interpolation
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 |
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.
3 Replies
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.
