joining 3 table to 1

[vjnvinod]

Dear community

@Zubair_Muhammad 

I have 3 table visuals like below

first table is budget table,

2nd table is actuals

3rd table is also actuals table but in periods.

i need to show this in 1 table

with budget, actuals & variance( Calculated column at end showing difference between  budget and actuals)

How do i do this?

[Gopal30]

You can do it in Query Editor. 

In Query editor in right hand corner of Home window you can see an option Append Query

Append Query--> Append Querys as New --> Three or more tables

OR

If all the above mentioned columns are from the same table then you can use Matix visual where you can introduce Subteam in Rows, Period in Column and Amounts in Values. Hope this might help.

Mark as answer if it solves your query!

[vjnvinod]

@Gopal30 

is this possible to do through a measure?

instead of doing this in power query.

[v-piga-msft]

Hi @vjnvinod ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, Please share your data sample with table format so that I could have a copy on it then have test.

Best  Regards,

Cherry

[Gopal30 · Accepted solution]

I am not sure about that, but you can have a look at this document which might help:

https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/