Scenario:
Suppose we have the sample of Product details as per below. In this sample we have 10 distinct Products and 3 unique Product Segments.
From this sample, we need to repeat the list of Products for each Product Segment.
ProdListBySegment =
let
Source = Product_Details,
ProdSegmentList = List.Distinct(Source[Prod_Segment]),
ProdNameList = List.Repeat(List.Distinct({Source[Prod_Name]}), List.Count(ProdSegmentList)),
TableFromProdLists = Table.FromColumns(ProdNameList, ProdSegmentList)
in
TableFromProdLists
Please Note:
I used above sample only to explain how this technique works. You can apply this technique for the right Scenario.
No comments:
Post a Comment
Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.