Forum Discussion
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...
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!
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!