Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

Split values by different levels

Hi Guys!

 

I'd like to create a report which give me a kind of What if.

 

In fact I'd like Power BI to provide proposition on stock allocation on one item reference splitted by multiple Sizes.

 

I give an example

 

In this example,

 

I'd like power BI to split The total Quantities by reference  "MAXVAN"  Which is 3 here.

 

1 Qty in size 10=4  in Stock 015

1 Qty in size 24=2  in Stock 015

1 Qty in size 35=1  in Stock 015

 

 

I'd like to share thes 3 sizes according to [Ranks] By [Code DEPOT]

 

Which means 

 

One quantity in Stock 010

One quantity in stock 040

One quantity in stock 015

 

I'm not able to manage it by using RANKX

 

i don't no if there's a way to achieve this?

 

here a link to the sample file

 

https://we.tl/t-EfrMQDvURw

 

 

Cordialy

 

 

 

Need Help

2 Replies

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      3 years ago

      Hello 🙂 these are only sizes to be considered as strings with no other interests.

       

      Like XS. S  M L XL for clothes 🙂 

       

      I would like to share one quantity by CODE ARTICLE  by warehouse.

       

      But share these according to the available quantities by size.

       

      In this example it will always be one quantity by size 

       

      Which in total makes 3 quantities by item.

       

      And I would like to split these items by each warehouse available (which have a rank) 

       

      Hehe 😊