Forum Discussion

Rubal's avatar
Rubal
Helper II
6 years ago
Solved

Calculated Column - Look up Value

Hi,   I need some help with a calculated column. I have a "Buy" table and a "Sell" table. I want to group all the subcategories from the "Buy" table and show it against the "Sell" table as an outpu...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Rubal 

    Create a new table

     

    link table =
DISTINCT (
    UNION (
        SUMMARIZE (
            sell,
            sell[Rest.Number],
            sell[Sub Category],
            sell[total sell],
            "cate", "totalsell"
        ),
        SUMMARIZE (
            buy,
            buy[Rest.Number],
            buy[Sub Category],
            buy[total buy],
            "cate", "totalbuy"
        )
    )
)

     

    Rename [total sell] as [value].

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Rubal 

Create a new table

 

link table =
DISTINCT (
    UNION (
        SUMMARIZE (
            sell,
            sell[Rest.Number],
            sell[Sub Category],
            sell[total sell],
            "cate", "totalsell"
        ),
        SUMMARIZE (
            buy,
            buy[Rest.Number],
            buy[Sub Category],
            buy[total buy],
            "cate", "totalbuy"
        )
    )
)

 

Rename [total sell] as [value].

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.