Forum Discussion
Creating two columns cash book
Hi austin316 ,
In my opinion ,it is earsier to get this in Power BI Desktop , you could add column in Power BI Desktop ,then publish to service ,and use Power BI Report Builder to get data from Power BI Service.See below for a quicker way to get the results you want, and don't bother with the complex statements in the Power BI Paginated Report Builder.
fact = CALCULATE(SUM('Table'[Debt]),FILTER('Table','Table'[Date]<=EARLIER('Table'[Date])))-CALCULATE(SUM('Table'[credit]),FILTER('Table','Table'[Date]<=EARLIER('Table'[Date])))Best Regards
Lucien
thanks for the above.
However what I desire is like below.
| Date | Debt | credit | Balance |
| 8/8/2022 | 4 | 0 | 4 |
| 8/9/2022 | 0 | 4 | 0 |
| 8/10/2022 | 10 | 0 | 10 |
| 8/11/2022 | 10 | 0 | 20 |
| 8/12/2022 | 0 | 5 | 15 |
1. [ 8/8/2022] Debt - Credit = [Balance]
2. [8/9/2022] what ever comes on either the [Debt or Credit] affect [add or substract ] the [balance]
Note: Not calcualting individual lines seperatly.
Hi austin316 ,
In my opinion ,it is earsier to get this in Power BI Desktop , you could add column in Power BI Desktop ,then publish to service ,and use Power BI Report Builder to get data from Power BI Service.See below for a quicker way to get the results you want, and don't bother with the complex statements in the Power BI Paginated Report Builder.
fact = CALCULATE(SUM('Table'[Debt]),FILTER('Table','Table'[Date]<=EARLIER('Table'[Date])))-CALCULATE(SUM('Table'[credit]),FILTER('Table','Table'[Date]<=EARLIER('Table'[Date])))
Best Regards
Lucien