Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |