Forum Discussion
joining 3 table to 1
Dear community
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?
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/
4 Replies
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!
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/
