Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Grouping by only sequential column values

Hello,    I have a dataset that I would like to create different groups of data by collecting data based on column values in one main column but only while those values repeat without skipping a ce...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi this is very close to the solution I need but I have run into some errors. Firstly, the actual data I am trying to use contains letters and numbers instead of just letters like the words "apple" and "orange". Secondly, I would like to count campaigns for the other "fruit" being made as well. So in this case this would be campaign number one for oranges. I would also like to count the number of baskets within the campaign. with another column titled "basket number this campaign" that resets after each campaign.

 

Could you please help me with this?

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

Thank you for your feedback.

Please share your sample pbix file, with some pictures of how your desired outcome looks like, then I can try to have a look into it.

Thank you.

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/