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 friends,
I need to calculate monthly sales amount for each customer ONLY IF the customer has a sales transaction of $500 and above.
If there is such a transaction, then I need to summ ALL of that customer's sales in that month.
It's like first selecting customers/month that have this transactions
and then selecting from the sales table joining with the previous results.
I was able to solve it using a calculated column and a measure.
But I am looking for an elegant all-in-one measure solution.
Thank you
Michael
Solved! Go to Solution.
So if we have this data:
We'd want bob to be 1500 and dave to be 2000 as they have individual line(s) of at least 500, but jim would be 0 as he doesn't? In that case, this works for me:
So if we have this data:
We'd want bob to be 1500 and dave to be 2000 as they have individual line(s) of at least 500, but jim would be 0 as he doesn't? In that case, this works for me:
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |