Forum Discussion

hidenseek9's avatar
hidenseek9
Icon for Post Patron rankPost Patron
7 years ago
Solved

How to append calculated column from one table with another table?

Hello Power BI Community,   I need a help with appending two tables together. What I would like to do is to append a calculated column from one table to another. Sample Power BI   In the attach...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi hidenseek9,

     

    I get it now. Try these table formulas, please.

    Table =
DISTINCT (
    UNION (
        SELECTCOLUMNS (
            Demand,
            "SKU Name Final", [SKU Name Final],
            "Date", [Date],
            "Sequence", [Sequence],
            "Gross Sales", [Demand Cab]
        ),
        SELECTCOLUMNS (
            'PL by SKU',
            "SKU Name Final", [SKU NAME],
            "Date", [Date],
            "Sequence", [Sequence],
            "Gross Sales", [GS - Gross Sales]
        )
    )
)

    Or,

    Table =
UNION (
    SELECTCOLUMNS (
        Demand,
        "SKU Name Final", [SKU Name Final],
        "Date", [Date],
        "Sequence", [Sequence],
        "Gross Sales", [Demand Cab]
    ),
    SELECTCOLUMNS (
        'PL by SKU',
        "SKU Name Final", [SKU NAME],
        "Date", [Date],
        "Sequence", [Sequence],
        "Gross Sales", [GS - Gross Sales]
    )
)

    How-to-append-calculated-column-from-one-table-with-another-table2

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi hidenseek9,

 

I get it now. Try these table formulas, please.

Table =
DISTINCT (
    UNION (
        SELECTCOLUMNS (
            Demand,
            "SKU Name Final", [SKU Name Final],
            "Date", [Date],
            "Sequence", [Sequence],
            "Gross Sales", [Demand Cab]
        ),
        SELECTCOLUMNS (
            'PL by SKU',
            "SKU Name Final", [SKU NAME],
            "Date", [Date],
            "Sequence", [Sequence],
            "Gross Sales", [GS - Gross Sales]
        )
    )
)

Or,

Table =
UNION (
    SELECTCOLUMNS (
        Demand,
        "SKU Name Final", [SKU Name Final],
        "Date", [Date],
        "Sequence", [Sequence],
        "Gross Sales", [Demand Cab]
    ),
    SELECTCOLUMNS (
        'PL by SKU',
        "SKU Name Final", [SKU NAME],
        "Date", [Date],
        "Sequence", [Sequence],
        "Gross Sales", [GS - Gross Sales]
    )
)

How-to-append-calculated-column-from-one-table-with-another-table2

 

Best Regards,
Dale