Equivalent DAX of FVSCHEDULE and CORREL functions in Excel

[Anonymous]

Hello,

I'm working on one financial model in which I have to achieve the same result as FVSCHEDULE and CORREL function generates in excel. But the problem is that I couldn't find any DAX function in Power BI like these.

Can anyone help me out with this how I can achieve the same result as below in Power BI?

I have attached the Demo Data Excel with the sample calculations.

Thank you in advance

[amitchandak · Accepted solution]

@Anonymous , for correl , refer this blog

https://www.bluegranite.com/blog/simple-linear-regression-in-power-bi

I can See FV- not FVSCHEDULE 

https://docs.microsoft.com/en-us/dax/financial-functions-dax

I covert FV and EMI in video

https://www.youtube.com/watch?v=9VYqbj2h4zE

https://www.youtube.com/watch?v=6oaSdjZ_FLQ