Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
76 | |
72 | |
65 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |