Forum Discussion

austin316's avatar
austin316
Regular Visitor
3 years ago
Solved

Creating two columns cash book

Hello Experts. Am having a bit of some challenge, trying to implement a two-column cash book logic as an expression on sql server report builder   The idea is to subtract [Debit amount] – [Credit...
expression
  • v-luwang-msft's avatar
    v-luwang-msft
    3 years ago

    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

     

dominek's avatar
dominek
New Member
3 years ago

It may be easier to solve this problem through Excel. Enter the formula in the line and get the report. I learned this in computer science college when we were taught these tables. Sometimes I missed school, but I still managed to study because of some services https://gradesfixer.com/free-essay-examples/freedom/ Then I worked at the cash register and dealt with similar tables