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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

Take last months known credit card balance and associate with correct category

At the moment this dax will take the previous end of day, end of month credit card value. It will then take the credit card payments throughout the month and any payments made into the credit card for that month. So below assumes start of the month the credit card didnt have any balance and by the end of the month is fully paid for as the transactions - credit payments = 0. However There was previous balance in the card already but with the nature of the columns it was under entertainment for the previous end of day, end of month credit card value. I would like to be able to move that value to credit payment or a new category seperate if needed






Community Support
Community Support

Hi @Jnickson49 ,

Do you want to get the correct credit card balance and match the balance to the correct category? Is the field [category] same table with the field [payment]? In order to get a better understanding on your problem and give you a suitable solution, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.