DAX Measure to calculate balance between two dates?

[Anmolgan]

I want to build a DAX formula that can calculate sales between two dates, 1 date is static that is end date, and 1 date is what I will let user pass and the formula should generate the balance as per that date for any given period, currently I am using below but it do not gives me exact results when I compare this to my SAP System, wondring what I have done wrong here.

Measure22 =

CALCULATE (

SUM ( 'Monthly Collection Report PBI'[Debit credit value]),

FILTER (

'Monthly Collection Report PBI',

[firstDateVisible] <= ( 'Monthly Collection Report PBI'[Posting date.Posting date Level 01.Key - Copy] )))

[Anonymous]

Hi @Anmolgan ,

Can you please share some sample data with minimum table structure and expected result for test? it is hard to coding formula without any detail information.

How to Get Your Question Answered Quickly  
Regards,

Xiaoxin Sheng

[Tahreem24 · Accepted solution]

Hi @Anmolgan ,

Please give a try to below measure:

Measure = 
CALCULATE (
    SUM ( ValueTable[Value] ),
    FILTER (
        ValueTable,
        ValueTable[Date] >= MIN( PeriodTable[StartDate] )
            && ValueTable[Date] <= MAX ( PeriodTable[EndDate] )
    )
)

 Please give KUDOS for support and also mark this as a solution if it helps you!

[Anonymous]

Good answer, but would like to know this:

How is ValueTable related to PeriodTable?