Forum Discussion
Calculating Monthly Balance Sheet - Help please
Hi Community, I am trying to create a Balance sheet dashboard with some measures / kpis etc. my data source is Microsoft navision 2016 and i have a live connection to the database. the two ta...
Hi
Are you searching like this
Not quite but i figured it out. i was able to obtain by using:
CumulativeTotal = CALCULATE(SUM('GL Entry 23'[2023 Amount]),FILTER(ALL('GL Entry 23'),'GL Entry 23'[Posting Date]<=MAX('GL Entry 23'[Posting Date])))