cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jnickson49
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
Jnickson49_2-1664565508396.png

Jnickson49_0-1664564956729.png

 

Jnickson49_1-1664565448867.png

 

 

1 REPLY 1
yingyinr
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

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.