Forum Discussion

tanveal's avatar
tanveal
New Member
3 years ago

table visual in powerbi

Hello, 

 

Is there way to perform calculations on the visuals rather than creating a measure or calculated column ?

I want to multiply price with tradeable QTY in the below visual, both columns are coming from different tables and SEC-ID is not unique in either so I cannot create 1-to many relationship (it's always many to many) so I cannot use Related function to connect two tables.

Just trying to think if there is workaround. Thank you

 

 

General Comment

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hello tanveal eventhough there is many to many relationship if you can confirm the values will be unique for each sec-ID then you can use 'LOOKUPVALUE' to get the details from another table. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

  • tanveal's avatar
    tanveal
    New Member
    3 years ago

    thanks Kishore, can you please give me example of the DAX formula I can use, lets say the column "TradebleaQTY" is in "QTY" table and column price is in "Price" table. If the values are indeed unique for each sec ID, how would the formula display ? Thank you