Forum Discussion

ABR002's avatar
ABR002
Helper I
5 years ago
Solved

Grouping/splitting a column

I have a list of items that are made at various factories. Some are made at only one factory, others are made at multiple factories, however the factory is only one column. What I need to do is split...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    ABR002 add a new column called Factory Number 

     

    Factory Number = "Factory " & RANKX ( FILTER ( Factory, Factory[Product # ] = EARLIER ( Factory[Product # ] ) ), Factory[Factory], , ASC )

     

    and in matrix visual use following

     

     

    and here is the output

     

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

     

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi ABR002 ,

 

I did the same test and thought that using matrix visual is the best choice. The table visual method will have an impact on the table structure, and the use of virtual tables cannot achieve this effect.

 


Regarding what you mean by the complex field, can you provide more information?


Best Regards,
Henry

 

  • ABR002's avatar
    ABR002
    Helper I
    5 years ago

    Nothing complex, there's just other data there, like sub skus or peoples names or regions, for now though I think this is fine.