data in seperating columns. How to do it?

[Ewa_28]

Hello,

I created the following formula: CombinedData =

    UNION(

        SELECTCOLUMNS(

            'Stemple',

            "Typ", "Sales",

            "Value", 'Stemple'[Sales],

            "Person", 'Stemple[Person],

            "Week", 'Stemple'[Week],

            "Q_numer", 'Stemple'[Q_numer],

            "Region", 'Stemple'[Region],

            "Year", 'Stemple'[Year]

        ),

        SELECTCOLUMNS(

            'Plany data',

            "Typ", "Plany",

            "Value", 'Plany data'[Value],

            "NPerson", 'Plany data'[Negocjator],

            "Week", 'Plany data'[Week],

            "Q_numer", 'Plany data'[Q_numer],

            "Region", 'Plany data'[Region],

            "Year", 'Plany data'[Year]

        )

    )

- it works. BUT I need data Plany and Sales in seperated columns. How to do it?

[Laxmanjatoth · Accepted solution]

try this 
CombinedData =
UNION(
SELECTCOLUMNS(
'Stemple',
"Typ", "Sales",
"Sales", 'Stemple'[Sales], -- Sales value in a separate column
"Plany", BLANK(), -- Empty (blank) for the "Plany" column
"Person", 'Stemple'[Person],
"Week", 'Stemple'[Week],
"Q_numer", 'Stemple'[Q_numer],
"Region", 'Stemple'[Region],
"Year", 'Stemple'[Year]
),
SELECTCOLUMNS(
'Plany data',
"Typ", "Plany",
"Sales", BLANK(), -- Empty (blank) for the "Sales" column
"Plany", 'Plany data'[Value], -- Plany value in a separate column
"Person", 'Plany data'[Negocjator],
"Week", 'Plany data'[Week],
"Q_numer", 'Plany data'[Q_numer],
"Region", 'Plany data'[Region],
"Year", 'Plany data'[Year]
)
)

[Laxmanjatoth · Accepted solution]

please  mark accept the solutions

[Ewa_28]

Hi @Laxmanjatoth 
Your solution works!!! Thank you very much.

Regards

[Laxmanjatoth · Accepted solution]

try this 
CombinedData =
UNION(
SELECTCOLUMNS(
'Stemple',
"Typ", "Sales",
"Sales", 'Stemple'[Sales], -- Sales value in a separate column
"Plany", BLANK(), -- Empty (blank) for the "Plany" column
"Person", 'Stemple'[Person],
"Week", 'Stemple'[Week],
"Q_numer", 'Stemple'[Q_numer],
"Region", 'Stemple'[Region],
"Year", 'Stemple'[Year]
),
SELECTCOLUMNS(
'Plany data',
"Typ", "Plany",
"Sales", BLANK(), -- Empty (blank) for the "Sales" column
"Plany", 'Plany data'[Value], -- Plany value in a separate column
"Person", 'Plany data'[Negocjator],
"Week", 'Plany data'[Week],
"Q_numer", 'Plany data'[Q_numer],
"Region", 'Plany data'[Region],
"Year", 'Plany data'[Year]
)
)