Forum Discussion
Creating table from a selected slicer value
I'm trying to create a table that would display the payment periods/month from a slicer value that is representing years so that I can calcluate the PPMT and IPMT values for each row/period. Exam...
Update: playing around it more, it looks like the issue is rooting from the Nper value. If i put it an actual number (example 360) it displays fine but when use something like "Loan Period Value*12" from the slicer it doesn't work.
Currently my loan Period value is Selectedvalue function
Hi Gutts_Zero ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng