Forum Discussion

CameronP's avatar
CameronP
Frequent Visitor
8 years ago
Solved

Create a Calculated Column from Different Tables

I'm having a very difficult time bringing information from one table into another. I have a Budget file with a data in it, such as branch, fund, budget, etc. I also have salary files with data in i...
Need Help
CameronP's avatar
CameronP
Frequent Visitor
8 years ago

Thanks for the reply Phil.

How does this work?
https://imgur.com/v3aeMEg

Imagine the Budget File and Salary File as two seperate files, and the Branch Library as an excel file that is linked (relationship) with the Branch number in each file (Salary and Budget) so that I can filter the information by the Branch name.

 

I'm new to Power BI and am finding it difficult to be able to filter by both fund and branch name. So I need to be able to say:
I want to see what my budget and salary is for branch "Orange" and fund 200" (there is much more data than 5 lines though haha).
I've tried merging the data and I can't, and I don't know enough about DAX to know if there is a way around. I've also tried filtering the data down to the fund inside of the actual query so that it only shows the funds I want to see, but unfortunately it's very time consuming as a few of my files are 1GB+. Any suggestions to be able to filter the information by both fund and branch?

Thanks so much for your time :)