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 column for the dashboard.  

Basically if the one column is blank then it needs to use the value from the next column.  Unfortunately I cannot create a custom column in this instance because I'm not using calculated columns, but measures instead.

Kind regards

  • 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 :)

2 Replies

  • 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.