Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi everyone,
I'm just wondering if you would know of any good power BI DAX measures that would be good to help a sales team analyse data?
Something a little more advanced if possible?
If so, would you be able to provide me with some sample measures and I can try them out?
Thank you so much in advance.
Solved! Go to Solution.
Hi @gbarr12345
Although I don't believe in learning something through formulas and think that formulas should come after a true understanding of the specific team's business processes, I'll attach some links to guides on sales team metrics that might give you some direction:
https://www.youtube.com/watch?v=eZ-389ufAEI
https://www.sqlbi.com/articles/finding-products-without-sales-by-using-dax/
https://www.youtube.com/watch?v=hgkTOpe3hFc
https://aplinnovation.ca/blogs/power-bi-playbook/3-dax-measures-ytd-previous-total
https://giulio.dk/dax-revenue-cost-and-profit/
https://www.youtube.com/watch?v=NH_cK5DMtss
https://www.youtube.com/watch?v=WdOiYJyRcmk
https://www.youtube.com/watch?v=ReNO_a6SApg
End-to-end projects :
https://www.youtube.com/watch?v=mo3jaS7LdaQ
https://www.youtube.com/watch?v=r2V0vFSOvjw
Good luck
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @gbarr12345
Although I don't believe in learning something through formulas and think that formulas should come after a true understanding of the specific team's business processes, I'll attach some links to guides on sales team metrics that might give you some direction:
https://www.youtube.com/watch?v=eZ-389ufAEI
https://www.sqlbi.com/articles/finding-products-without-sales-by-using-dax/
https://www.youtube.com/watch?v=hgkTOpe3hFc
https://aplinnovation.ca/blogs/power-bi-playbook/3-dax-measures-ytd-previous-total
https://giulio.dk/dax-revenue-cost-and-profit/
https://www.youtube.com/watch?v=NH_cK5DMtss
https://www.youtube.com/watch?v=WdOiYJyRcmk
https://www.youtube.com/watch?v=ReNO_a6SApg
End-to-end projects :
https://www.youtube.com/watch?v=mo3jaS7LdaQ
https://www.youtube.com/watch?v=r2V0vFSOvjw
Good luck
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you very much for all of those resources Rita! Much appreciated!
Happy to help, Goodluck again 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |