Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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. 🙂