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.
Was trying to figure out how to Group By two columns (from two separate (but related) tables). Then finding the sum from another related column in a different table.
Group by Customer, Sales Rep and Sum Invoice totals - Goal: to determine the total amount of invoiced sales for each rep.
Total Dollars = GROUP BY(Sales Rep[Sales Rep Name], SUM(Sales Details[Sales Line Sales Amount]))
I also need to round these final figures up.
Solved! Go to Solution.
Here's what I did to solve this one. Any ideas or ways to make it better or more efficient are welcome! 😄
Code: New Customer Points Per Dollar = CALCULATE(ROUNDUP( SUM('SALES DETAILS'[Sales Line Sales Amount]),0), ALLEXCEPT('Sales Rep', 'Sales Rep'[Sales Rep Name]))
Here's what I did to solve this one. Any ideas or ways to make it better or more efficient are welcome! 😄
Code: New Customer Points Per Dollar = CALCULATE(ROUNDUP( SUM('SALES DETAILS'[Sales Line Sales Amount]),0), ALLEXCEPT('Sales Rep', 'Sales Rep'[Sales Rep Name]))
Here are some resources I used to help figure it out. 🙂
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 |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |