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

     

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi austin316 ,

What I uesd is  Power BI Report Builder，you could test it to create new column:

.Difference between Power BI Report Builder and Microsoft Report Builder：

 

Power BI Report Builder is optimized for RDL reports in the Power BI service, which can log into Power BI, allow you to open and save reports from the workspace, and support querying Power BI advanced datasets and datasets of non-advanced users that have been published to the service.

 

base data:

 

 

new field:

 

Output result:

 

Best Regards

Lucien