Forum Discussion
Grouping using an IF Function around in data conditions
Hi ElliotP,
I'm not able to download the .pbix file. Would you please upload the file to your OneDrive and share the link here?
Best Regards,
Qiuyun Yu
- ElliotP9 years ago
Post Prodigy
I've re-typed what I'm trying to achieve if this might help add some clarity to what I'm trying to do.
I feel there are two conditions.
The first being, if there are multiple different unique transaction IDs within a ten minute rolling period have the same value such as “25in” appear in the Notes column of the ‘itemdetailsdogfood$’ table then these orders are classified as being a part of a group of people. So if for example there were 3 Unqiue transaction IDs between 8.21am and 8.27am with the same Note “25 In” for example then that is a group of three people.
The next part is if on a Unique Transaction ID there is more than one of any item category in the [Section2] category then the subsequent numbers represent an additional person. So each group begins with one person. If for example there are two “barista” values which appear within one Unique Transaction ID then that represents a group of two people.
From those two sets of conditions I would like to be able to build a table which showed the Group Size (one person, two people, three people, etc) and the number of groups. I would also like to be able to filter this by the datetable as well as ideally using filters so I am able to filter just the groups that order something from [Section2].
- ElliotP9 years ago
Post Prodigy
Thoughts?