Calculate balance from debit and credit foe each customer

[aqsasaleem]

I am trying to calculate Total balance from debit and credit columns. but my formula is not adding debit values and subtracting credit values it's showing same value in balance. it should be customer and date wise (date from older to newer). I will show one customer at a time in my report on user selection based.

[Fowmy]

@aqsasaleem 

Please try this measure:

Balance =
CALCULATE ( [Debit Balance], tablename[date] <= MAX ( tablename[date] ) )
    - CALCULATE ( [Credit Balance], tablename[date] <= MAX ( tablename[date] ) )

[aqsasaleem]

@Fowmy I used your formula it's working but where dates are same (Transactions on same date) it is grouping values. any solution?

Formula is 

Balance =

CALCULATE (

    CALCULATE ( SUM ( cl_resultset[md_debit] )

        - CALCULATE ( SUM ( cl_resultset[md_credit] ))),

    FILTER ( ALL ( cl_resultset[md_date], cl_resultset[cl_type], cl_resultset[md_name], cl_resultset[md_description]), cl_resultset[md_date] <= MAX ( cl_resultset[md_date] ) )

)

and result is

[Fowmy · Accepted solution]

@aqsasaleem 

Try this measure:

Balance =
CALCULATE (
    SUM ( cl_resultset[md_debit] ) - SUM ( cl_resultset[md_credit] ),
    WINDOW (
        1,
        ABS,
        0,
        REL,
        SUMMARIZE (
            ALLSELECTED ( cl_resultset ),
            cl_resultset[md_date],
            cl_resultset[refernce number]
        )
    )
)

[aqsasaleem]

@Fowmy Thank you so much it's working 😊

[Dangar332]

Hi, @aqsasaleem 

try below

Balance =
var a = MAX ( tablename[date] )
var b = CALCULATE ( [Debit Balance], tablename[date] < MAX ( tablename[date] ) )+a
var c = CALCULATE ( [Credit Balance], tablename[date] <= MAX ( tablename[date] ) )+a
return
b-c

[salvalcaraz]

This topic is very similar, check it out
Solved: Re: calc balance from debit and credit - Microsoft Fabric Community