Calculate balance of account with timeslicer

[infophyxius]

Hi,

I have a problem: 

I want to calculate for example the balance at the end of the day 06.05.2017, which is equal = Sum of A from Debit– Sum of A from Credit (in this case: 1000-500+8000-200).

It is possible to calculate this sum with a timeslicer?

Date	Debit	Credit	Sum
02.03.2017	A	X	1000
03.03.2017	X	A	500
05.05.2017	A	X	8000
06.05.2017	X	A	200
07.05.2017	A	X	1000

A Account Balance 06.05.2017 = Debit A – Credit A = 1000+8000-500-200

Thank you,

L.

[v-huizhn-msft · Accepted solution]

Hi @infophyxius,

Please create a measure using the formula:

A Account Balance 06.05.2017 =
SUMX (
    FILTER ( Table1, Table1[Date] <= DATE ( 2017, 6, 5 ) && Table1[Debit] = "A" ),
    Table1[Sum]
)
    - SUMX (
        FILTER ( Table1, Table1[Date] <= DATE ( 2017, 6, 5 ) && Table1[Credit] = "A" ),
        Table1[Sum]
    )

Then create a card visual to display the result, please see the following screenshot.



Best Regards,
Angelia

[infophyxius]

Thank you very much!