Forum Discussion

BICrazy's avatar
BICrazy
Icon for Helper II rankHelper II
6 years ago
Solved

Combine 2 Measures into 1 Column

Hi,   I have 2 measures that were each created from separate tables which are labelled Sales Conversion Rate as per the screenshot attached. I'd prefer to display both of these measures as one colu...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    I think an IF Statement would do.

     

    New_Column:= IF(Table[Sales_Conversion1]<>BLANK(),Table[Sales_Conversion1],Table[Sales_Conversion2])

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

I think an IF Statement would do.

 

New_Column:= IF(Table[Sales_Conversion1]<>BLANK(),Table[Sales_Conversion1],Table[Sales_Conversion2])

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)

  • BICrazy's avatar
    BICrazy
    Icon for Helper II rankHelper II
    6 years ago

    Anonymous  - Hi, I've changed the measures to calculated columns. However, the IF statement won't work in this situation because the calculated columns are in separate tables and I cant create a relationship between the 2 tables because none of them contain unique values.