Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.