Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am quite new to PowerBI and this is my first time posting here.
What I am trying to accomplish is to retrieve the sum of all sales that are above a certain day threshold and aggregate these values per week.
I have the following example data:
Sales
Date | Time | Net sales |
1-5-2023 | 13:00 | 100 |
1-5-2023 | 14:00 | 50 |
1-5-2023 | 15:00 | 70 |
2-5-2023 | 12:00 | 150 |
2-5-2023 | 16:00 | 30 |
3-5-2023 | 10:00 | 200 |
4-5-2023 | 11:00 | 160 |
4-5-2023 | 11:00 | 10 |
5-5-2023 | 13:00 | 80 |
5-5-2023 | 14:00 | 150 |
5-5-2023 | 15:00 | 20 |
6-5-2023 | 15:00 | 170 |
7-5-2023 | 12:00 | 190 |
7-5-2023 | 16:00 | 40 |
Threshold
Date | Threshold |
1-5-2023 | 150 |
2-5-2023 | 190 |
3-5-2023 | 250 |
4-5-2023 | 180 |
5-5-2023 | 150 |
6-5-2023 | 200 |
7-5-2023 | 200 |
Solved! Go to Solution.
You need a dimensional table for the date to bring both tables together in a model:
Here is the measure, you have to calculated the difference within the dates
Proud to be a Super User!
You need a dimensional table for the date to bring both tables together in a model:
Here is the measure, you have to calculated the difference within the dates
Proud to be a Super User!
Wow, you are fast! Your solution works like a charm. I am not yet familiar with the summarize function of DAX, so i'm gonna try and figure out exactly how the formula works. Thank you very much! 🙂
Enjoy your journey in DAX 🙂
Proud to be a Super User!
You calculated the sum in your var and than you check if the sum is greater as 0.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |