cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

No.of outlet in which product is reordered

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

4 REPLIES 4
Community Support
Community Support

Hi @Varsri ,

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Super User IV
Super User IV

@Varsri , this does seem like the data from which we can reproduce the output you want. can you share sample raw data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User III
Super User III

Hi @Varsri ,

 

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors