Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
ALGA11
New Member

Need help - Fill dates columns with values - DAX

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:

 

AAA.png

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:

bbb.png

How I need it: 

ccc.png

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,

 

1 ACCEPTED 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

Screenshot_4.png

View solution in original post

5 REPLIES 5
ALGA11
New Member

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

Ahmedx
Super User
Super User

pls try this

Screenshot_2.png

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

 

ALGA11_0-1704905632639.png

 

 

[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

Screenshot_4.png

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors