Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi there,
please, I need help,
I have a credit portfolio database (here in the forum I not using real values, but the structure is the same. In the database, in order of the columns, from left to right have the the portfolio data position, the partner name, the the total value (which i already have ready and calculated), the installment quantity and the maturity date. This is my exemple table:
My problem is that I need to create a Matrix visual that shows the installments repeating multiple times until they reach the maturity date. My matrix needs to have the maturity date on the columns, the installments on the lines and the installment value as value. For example, the installment of $ 30685,22, which matures in march needs to appear both in february and march columns, but wit my current database it only shows on march. The partner name will be use just for segmentation. I'll post how the current data base looks in the matrix and how I would like it:
How it is now:
How I need it:
It would be great if sme kind soul could help me, I tried many times with DAX, but i couldn't do much.
Many thanks in advance,
Solved! Go to Solution.
[m1] this is a measure you need to create it
and you need to create a date table and disable hierarchy
look carefully at the model and how I created the relationship between the tables
Hi @Ahmedx, it worked now, thank you so much for your kind help! I Wish you all the best.
I'm glad I could help you
Thank you for you kind support, @Ahmedx, but I still couldn't make it work. The resolution you showed is what I'm looking for, but I got some errors. The first one, and I think I solved myself, in the line 4 of the DAX you created, i changed the "date[maturity date]" for 'Table'[maturity date], because I don't have a "date" table. The other error is on that "[m1]", power bi gave the error (I translated to english because I'm using the Brazilian power bi): "Unable to locate column 'm1' or it is not allowed to use it in this expression."
Do you have some ideia on how to solve this? anyway, thank you for the last answer
[m1] this is a measure you need to create it
and you need to create a date table and disable hierarchy
look carefully at the model and how I created the relationship between the tables