{"id":774,"date":"2025-09-19T08:48:59","date_gmt":"2025-09-19T08:48:59","guid":{"rendered":"https:\/\/datadandies.nl\/?p=774"},"modified":"2025-09-19T08:48:59","modified_gmt":"2025-09-19T08:48:59","slug":"calculate-running-total-in-power-bi-method-3-using-a-measure-with-no-calculate","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2025\/09\/19\/calculate-running-total-in-power-bi-method-3-using-a-measure-with-no-calculate\/","title":{"rendered":"Calculate running total in Power BI &#8211; Method 3 &#8211; Using a measure with NO CALCULATE"},"content":{"rendered":"\n<p>In the last post we calculated the running total of bank account transactions (withdrawals and deposits) using a measure containing the function CALCULATE in Power BI. In the image below we use a measure without the function CALCULATE.<\/p>\n\n\n\n<p>Zooming in on the RunningBalanceMeasureNoCalculate value of &#8220;1300&#8221; in the screenshot below: the first three rows adhere to both filter conditions in the variable &#8220;_Table&#8221;. After all, the dates of the first three rows are all smaller than 8\/3\/2025 and they all share the account &#8220;A&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"902\" height=\"517\" src=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2025\/09\/20250919-Cumulative-amount-per-bank-account.png\" alt=\"\" class=\"wp-image-775\" srcset=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2025\/09\/20250919-Cumulative-amount-per-bank-account.png 902w, https:\/\/datadandies.nl\/wp-content\/uploads\/2025\/09\/20250919-Cumulative-amount-per-bank-account-300x172.png 300w, https:\/\/datadandies.nl\/wp-content\/uploads\/2025\/09\/20250919-Cumulative-amount-per-bank-account-768x440.png 768w\" sizes=\"auto, (max-width: 902px) 100vw, 902px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In the last post we calculated the running total of bank account transactions (withdrawals and deposits) using a measure containing the function CALCULATE in Power BI. In the image below we use a measure without the function CALCULATE. Zooming in on the RunningBalanceMeasureNoCalculate value of &#8220;1300&#8221; in the screenshot below: the first three rows adhere&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2025\/09\/19\/calculate-running-total-in-power-bi-method-3-using-a-measure-with-no-calculate\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3],"class_list":["post-774","post","type-post","status-publish","format-standard","hentry","category-blog","tag-powerbi"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=774"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/774\/revisions"}],"predecessor-version":[{"id":776,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/774\/revisions\/776"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}