Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a Calculated Column Based on 2 tables

I have this created this table which is a Union of several other tables. 

 

I want to add a Cost per INQ (top row example for Blackhat = $112,139 / 444 INQs = $252.56 = Cost/Inq) as a column on the end of this table. What is the best way to do this?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    is both Cost and INQ columns are in the same source table ?

    Option 1: you can create a Column in Power Query Editor

    Option 2: create a measure as follows:

           Cost Per INQ = Cost - INQ

    and drag it to this table Visual.

     

    am not sure if am missing something but looks simple to me based on what you have provided below.

    Thanks!

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Without knowing how the data is set up, I'm not sure if this will solve your problem, but a measure built something like this should get the desired result:
    Measure = 
    DIVIDE (
        SUMX( table, table[cost]), SUMX( table2, table2[INQ]), 0)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    is both Cost and INQ columns are in the same source table ?

    Option 1: you can create a Column in Power Query Editor

    Option 2: create a measure as follows:

           Cost Per INQ = Cost - INQ

    and drag it to this table Visual.

     

    am not sure if am missing something but looks simple to me based on what you have provided below.

    Thanks!