Table of all possible combinations

[Anonymous]

Hi, 

I have a list of 4 business units (BU) and I want to give each BU an score, A, B, C depending on some given criteria.  In below list there are 8 combinations, on rows 1-3 each BU gets the same score and on rows 5-8 there are some combinations with only A and B scores. How can I get a table of each possible combination?

#	BU1	BU2	BU3	BU4
1	A	A	A	A
2	B	B	B	B
3	C	C	C	C
4	A	B	A	A
5	A	A	B	A
6	A	A	A	B
7	A	B	B	A
8	A	B	B	B

...and so on...

Best regards,

Chris

[Greg_Deckler · Accepted solution]

@Anonymous I think maybe this:

Table = 
    GENERATEALL(
        GENERATEALL(
            SELECTCOLUMNS({ "A", "B", "C" },"Value1",[Value]),
            SELECTCOLUMNS({ "A", "B", "C" },"Value2",[Value])
        ),
        GENERATEALL(
            SELECTCOLUMNS({ "A", "B", "C" },"Value3",[Value]),
            SELECTCOLUMNS({ "A", "B", "C" },"Value4",[Value])
        )
    )

[Anonymous]

Hi, @Greg_Deckler , thanks a lot, this works perfect.