Adding together multiple different data sources

[thinkvisual]

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

[Anonymous]

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]

@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]

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

[thinkvisual]

Hi @Anonymous  - thank you for the fast reponse!

Honestly dont know how I can be any clearer than the pink mark up on the image above.

I'm trying to add those fields together to put in the top bar of the funnel

(they are connected by date in the data model)

Many thanks 

David

[Anonymous]

Hi @thinkvisual ,

What happens when you drag and drop the fields?

Cheers

A

[thinkvisual]

Hi @Anonymous 

I believe you can only drop in one field per bar

I will also need to accumulate data for other visuals – which  makes me believe this definitely requires a calculation.

Am I correct in thinking that a calculated column is per source – so for eample in the image below, I could have one column for CRM, one for FB Accounts, one for posts, or can it bring together fields from across all three?

Many thanks

David

[Anonymous]

Hi @thinkvisual 

I advise you to try. See what happens. Experiemnet things. Try and error.

That's the way to learn new things. After that return with focused questions.

The questions you have are very basic and not clear to me what your issues are, if any.

I am not aware of any limitations in the # of calculated columns per source.

I have sources with 10+ such columns.

Good luck!
A