Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I need a help to create a measure. My requirement is that When a new product is sold for the first time in the outlet, it will be a normal sale. If the same product is sold for the second time and after, it will be a reorder sale. How to find No.of outlet in which product is reordered with respect to week.
No. of Outlet Week No.of outlet in which product is reordered
10 1 0
15 2 12
18 3 15
20 4 16
Thanks,
varsri
Hi @Anonymous ,
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , this does seem like the data from which we can reproduce the output you want. can you share sample raw data.
Hi @Anonymous ,
Does the screenshot contains the actual data you want to use for the report?
Your 3rd column is quite confusing.
Consider Row 2 of your data, How can there be an "No. of Outlet in which product Reordered" = 12 for "No. of Outlet" = 15.
Both of these column represent a Unique ID/Number representing an OUTLET.
Thanks,
Pragati
Hi Pragati,
Thanks for giving valuable time. This is not a actual data. eg. No. of outlet in 1st week is 10 & in 2nd week it is become 15 , 5 new outlets added in 2nd week as cummlative inceasing. In 3rd week 3 new outlets added, now 18 outlets.
I have to find the no of outlets in which product is reordered. Suppose, from 10 outlets in a 1st week no outlet has given reorder for that product. that become 0 no. of reordered outlet.
In 2nd week out of 15 outlets, 12 outlets have given again order for this product. How i can get total no of reordered outlets in given week. That is a requirement.
Thanks
Varsri
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |