Creating a new Measure based on two colums in Table

[mattschupbach]

I am looking to calculate utilization of space for sales. Column 3 * column 4 = column 5 

[RafaelBarrios]

Hi @mattschupbach 

that would be 

In column 5 measure use this expression

column(3)*column(4)

Be aware that:

1. this only works for measure and not dimension

2. dimension doesn’t count as column number

3. user can move column, so it would be better if you use master measure names.

let’s say you column 3 measure is master measure Unit Price and column 4 is master measure Quantity.

your column 5 would be

[Unit Price]*[Quantity]  

that if you are working in visualization, you can always do it in script with

load
Field1,
Field2,
Field3*Field4 as field5
FROM <wherever>;

hope this works.

Best,

[RafaelBarrios]

Hi @mattschupbach 

Any news?

Help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂