topic Re: Generating pairs of names in DAX Commands and Tips

Generating pairs of names

CHCHJOSIE — Sun, 01 Oct 2023 06:17:31 GMT

We have a list of 40 team members, each month I am wanting to pair all the people in the list up (coffee roulette) and I don't want any duplicates in subseqent pairings. People may be added and removed month to month.

I have been searching Google, this community, trying Chat GPT but so far have not gotten close to how it could be done.

Any ideas?

Re: Generating pairs of names

lbendlin — Sun, 01 Oct 2023 21:39:15 GMT

Sounds like a standard cross join with a couple excepts thrown in.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Generating pairs of names

CHCHJOSIE — Sun, 01 Oct 2023 22:15:22 GMT

Hi lbendlin , Thanks for your response. I should have clarified further. At the moment I have 2 Smartsheets, 1 which has the list of names and the other which has the pairings that have already occurred (not sure if I need the second sheet).

Sheet 1 is called Members and just has the names -

Bob Jones

Cathy Smith

Lisa Simpson

Sarah Turner

Scott Swift

Mark Jones

Tim Kitchen

Peter Robins

Francis Banks

Amy Ocean

* fake names 🙂

Sheet 2 is called Matchings and has previous pairings -

Bob Jones	Cathy Smith
Lisa Simpson	Sarah Turner
Scott Swift	Mark Jones
Tim Kitchen	Peter Robins
Francis Banks	Amy Ocean

I want to be able to generate new pairings taking into account previous pairings so there are no duplicates.

Re: Generating pairs of names

lbendlin — Mon, 02 Oct 2023 11:56:39 GMT

Please provide sample data that fully covers your issue.