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.

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi Rubal,

I have adjusted the data model (see figure) and used the Rest. Number and SubCategory field from the bridge tables:

 

 

Regards FrankAT

  • Rubal's avatar
    Rubal
    Helper II
    6 years ago

    Hi FrankAT . Thanks for your advise. I have tried doing it. Howver, as I have some other table which have existing relationship with both buy and sell table, I couldn't activate the relationship with the bridge as you have shown. any chance of helping me with the formula?