Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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