Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have a table where the bank movements relating to various accounts are recorded, positive (income) and negative (outgoing). I would like to make a graph that shows the balance as a function of time (date). I tried to set up a quick measure (running sum) but it doesn't work.
Here an example of my table:
ACCOUNT | TYPE | DESCRIPTION | VALUE | DATE |
ALPHA | 7 | xxxx | $ 26.235,37 | 04/11/23 |
ALPHA | 7 | ewcx | $ 10.605,84 | 04/11/23 |
ALPHA | 7 | xewqdef | $ 49.955,20 | 04/11/23 |
ALPHA | 7 | ewff | $ 7.008,00 | 04/11/23 |
BETA | 7 | dfewfd | $ 878,40 | 04/11/23 |
BETA | 7 | gwe | $ 14.003,55 | 04/11/23 |
BETA | 7 | hwtht | $ 9.205,34 | 04/11/23 |
GAMMA | 8 | htrh | $ 4.861,70 | 04/12/23 |
ALPHA | 7 | sbrb | $ 7.831,91 | 04/12/23 |
GAMMA | 7 | htwrh | $ 126.349,28 | 04/12/23 |
BETA | 7 | btwbw | $ 28.459,15 | 04/12/23 |
ALPHA | 7 | vbvw | $ 250.578,12 | 04/13/23 |
BETA | 7 | bvrb | $ -250.578,12 | 04/13/23 |
DELTA | 2 | btrwesb | $ -48,00 | 04/13/23 |
OMEGA | 2 | bbrb | $ -25.000,00 | 04/13/23 |
ALPHA | 7 | hg | $ 25.000,00 | 04/13/23 |
ZETA | 2 | nmnu | $ -75.000,00 | 04/13/23 |
Solved! Go to Solution.
If you have a date table linked to your fact table you can use
Running Total =
VAR CurrentDate =
MAX ( 'Date'[Date] )
RETURN
CALCULATE ( SUM ( 'Table'[Value] ), 'Date'[Date] <= CurrentDate )
If you have a date table linked to your fact table you can use
Running Total =
VAR CurrentDate =
MAX ( 'Date'[Date] )
RETURN
CALCULATE ( SUM ( 'Table'[Value] ), 'Date'[Date] <= CurrentDate )
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |