Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
Thank you very much!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |