Hi everyone,I have a table and I would like to get Estimate Sale by Speed for a month
I'm having difficulty in writing formulas DAX for this case
For example, as shown below
Please see the attached file
I'm looking forward to your reply
Thank you in advance
Go to Solution.
@nmhung49 try this measure:
Est Speed Sale = SUMX(SUMMARIZE(Sale,Sale[PCA],EstDate[EstDate],"@Avg",[Avg Sale Per Day]),[@Avg]*[EstDate])
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.