cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tatmel Frequent Visitor
Frequent Visitor

Balance amount calculation based on day, week , month, quater, year selecton

How to calculate balance of the account based on selected detailed period, f.e. month selection.

 

I want from the system calculate running total (Balance) of GL account (summarising each amount of the transaction starting from the begining of the history until the end of each month). How can I achieve it?

 

 

изображение.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Balance amount calculation based on day, week , month, quater, year selecton

There is a built in running total quick measure, I would start with that. Or see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: Balance amount calculation based on day, week , month, quater, year selecton

There is a built in running total quick measure, I would start with that. Or see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!