Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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!
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |