Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vjnvinod
Impactful Individual
Impactful Individual

joining 3 table to 1

 

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?

budgetactual.PNG

 

 

1 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/

 

 

View solution in original post

4 REPLIES 4
Gopal30
Helper I
Helper I

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

 

ans.PNGans1.PNG

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
Impactful Individual
Impactful Individual

@Gopal30 

 

is this possible to do through a measure?

instead of doing this in power query.

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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/

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.