Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello,
I am having some difficulty calculating the measure total. I have a list of multiple promotions. The goal is to calculate the total sales 30 days after the promo end date. I have the row level working, but the total only shows the row value for the MAX date.
Any ideas on how I can get this to work?
Current DAX:
Current Result | ||
Promo Name | Promo End Date | Total Sales 30 days After |
Promo 1 | 4/30/2019 | $458,664 |
Promo 2 | 8/31/2019 | $262,729 |
Promo 3 | 5/31/2020 | $6,488 |
Promo 4 | 9/30/2020 | $21,360 |
21,360 | ||
Desired Result | ||
Promo Name | Promo End Date | Total Sales 30 days After |
Promo 1 | 4/30/2019 | $458,664 |
Promo 2 | 8/31/2019 | $262,729 |
Promo 3 | 5/31/2020 | $6,488 |
Promo 4 | 9/30/2020 | $21,360 |
$749,241 |
Solved! Go to Solution.
I figured out a solution for my issue.
I was able to create another measure and using SUMX referenced the first measure. Thanks!
I figured out a solution for my issue.
I was able to create another measure and using SUMX referenced the first measure. Thanks!
Try first calculating your promo date as a variable up front.
Current DAX:
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks. I tried that but it still returns the value for the last date and not the Sum.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
103 | |
63 | |
45 | |
37 | |
35 |