Forum Discussion

third_hicana's avatar
third_hicana
Icon for Helper IV rankHelper IV
2 years ago

Merge Queries Without Repeating the Values

Hi Everyone. Askig for help regarding my data model and merging columns   I have two tables with one-to many relationship. I want to avoid repeating the values of 'Value' in Table 1 when merging to...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
data model and merging columns

There's your answer. Don't merge.  Use the data model.

  • third_hicana's avatar
    third_hicana
    Icon for Helper IV rankHelper IV
    2 years ago

    lbendlin  Thank you.

     

    How can I create a measure that the capex and opex 'baseline budget £' will only appear once in the table visual? 

     

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      What would be your criteria? MIN of BOP+Suffix ?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        If yes then add that filter to your measure.