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
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!