Forum Discussion

thinkvisual's avatar
thinkvisual
Frequent Visitor
7 years ago

Adding together multiple different data sources

Hi there,

 

I am trying to add up multiple sources of data to put into one visual as shown below, for example impressions from mulitple sources, or engagement from multiple sources. But not sure how as the data is coming from different data sets.

 

So far I have looked at

Quick measures - but this seems to be only two sources

Calculated columns - but i think this has to come from the same data set(?) even though I have created a relationship.

 

I'm not sure if I have to write this in Dax - not something that I have done before - can anyone advise?

 

Thanks

David

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi thinkvisual 

    I am not sure I am following.

    Anyhow, there is no prevention to use multiple sources in one visual.

    Yes, it is important/crucial to have your relationship(s) in place.

    Good luck!
    A

    • thinkvisual's avatar
      thinkvisual
      Frequent Visitor
      7 years ago

      Anonymous To simplify my question: how can I combine 4+ fields from different data sources?

      I thought a quick measure was for a max of 2 items - and a custom column works per table of data from each uploaded XLS sheet(?) My data is coming from multiple XLS sheets as shown in the picture.

       

      Many thanks

      David

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi thinkvisual 

        Again, I am not following.

        Maybe give samples of your data and the required results?!

        You need to define the relationships between the tables in your data model.

        Then just use the columns whereever you wish.

        Thanks,

        A