Help with Dax

[SachinFG]

Hi team,

I am stuck with dax to calculate the total sum for a dealer sales for the promotional period. sample data is below.

end result required is for dealer 5032917 total sum would be $36000. 

There will be dealer sales after the end of promotionla period which is not requirted to be calculated. 

Thanks in advance.

Dealer	Start	End	value
5032917	1/10/2022	21/10/2022	$12,000
5032917	1/07/2023	28/07/2023	$12,000
5032917	1/09/2022	15/09/2022	$12,000

[v-yangliu-msft · Accepted solution]

Hi  @SachinFG ,

Calculated column.

Column =
SUMX(
    FILTER(ALL('Table'),
    'Table'[Dealer]=EARLIER('Table'[Dealer])),[value])

measure.

Measure =
SUMX(
    FILTER(ALL('Table'),
    'Table'[Dealer]=MAX('Table'[Dealer])),[value])

Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly