Help with dax measure

[SachinFG]

Hi team,

Need help in figuring out the dax to calculate the sum of values for a given merchant with the start and end date.

There are sales ouside the start and end date but need to caluclate only cummulative sales for the below 3 promo dates.

 so for merchant 5032917, the value should be $37000.

Merchant	start	end	value
5032917	10/01/2023	21/01/2023	15000
5032917	1/03/2023	28/03/2023	12000
5032917	5/02/2023	26/02/2023	10000

[tamerj1 · Accepted solution]

Hi @SachinFG 
'Date' is a disconnected table

Sales Amount =
SUMX (
    FILTER (
        SaLes,
        Sales[Start] <= MAX ( 'Date'[Date] )
            && Sales[End] >= MAX ( 'Date'[Date] )
    ),
    Sales[Value]
)

If 'Date' is connected then try

Sales Amount =
SUMX (
    FILTER (
        ALL ( SaLes ),
        Sales[Start] <= MAX ( 'Date'[Date] )
            && Sales[End] >= MAX ( 'Date'[Date] )
    ),
    Sales[Value]
)