Forum Discussion
Help with Dax
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 $3600...
Hi Anonymous ,
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
Hi Anonymous ,
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