Creating table from a selected slicer value

[Gutts_Zero]

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.

Example slicer ranges from 1-30 years. If i select the 25 from the slicer, the table would display 25*12 = 300 rows.

Can anyone give assist?

[Gutts_Zero]

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

[Anonymous]

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

[Anonymous]

Hi @Gutts_Zero,

What type of table you mean? If you mean the calculated table, current power bi does not support to create dynamic calculated column/table based on filter effect, they do not work on the same data level, and you can't use child level to effect its parent level.

If you mean table visual, you should create a unconnected table or what if parameter table as source of slicer.

Then you can write a measure formula as filter to use on table visual to apply custom filter effect based on your selection.

Applying a measure filter in Power BI - SQLBI

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

[Gutts_Zero]

I already have a what if parameter table as the source of slicer and I already have a table to contain the periods. 

PMT calculate fine, it seems the issue is when I use the max() function to calculate the either the ppmt or ipmt of the respective row/period. 

As seen in the screen shot below, pmt calculates and displays on the table visual as well as the dax formula for ipmt.

But when i put the ipmt into the visual table i get the error.