Forum Discussion

Ewa_28's avatar
Ewa_28
Helper II
1 year ago
Solved

data in seperating columns. How to do it?

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?
  • 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]
    )
    )

3 Replies

  • 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]
    )
    )