Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to 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
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
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |