I have a seperate table for inventory and sales. In both tables, for particular item code there are different order date and for particular item code there are different purchase date. I need to create a column quantity, which displays there are these much quantities sold on the same date. And I need to calculate the frequency of days the order has been sold. Kindly help me with this
Hi Khánh, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. In that case, although order date is same for both the transactions, order number will be different. So, you'll be required to write a condition wherein latest Order Date and Order Number is considered. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! If you haven't yet, you can subscribe to our RUclips channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
Check out our FREE courses: bit.ly/3N00AJw
Very useful thanks
Great explanation.. 👍
Top quality content as always 👍
I have a seperate table for inventory and sales. In both tables, for particular item code there are different order date and for particular item code there are different purchase date. I need to create a column quantity, which displays there are these much quantities sold on the same date. And I need to calculate the frequency of days the order has been sold. Kindly help me with this
Lastdate not work with dumplicate date when a customer Purchase two times in one order date. What about this case?
Hi Khánh,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
In that case, although order date is same for both the transactions, order number will be different. So, you'll be required to write a condition wherein latest Order Date and Order Number is considered.
For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful! If you haven't yet, you can subscribe to our RUclips channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/