Forum Discussion

olindeman's avatar
olindeman
New Member
10 years ago
Solved

Power BI Relationship Help

I have 2 excel files. One has all my main data but the data source does not always have a clean Account Name value, and many of my Accounts Number change from year to year. I have another table with ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    olindeman You could create a calculated column in the 2nd table to determine the "Account" that you want to use...

    Account = IF(Table2[Parent Account] = BLANK(), Table2[Account Number], Table2[Parent Account])

olindeman's avatar
olindeman
New Member
10 years ago

Would this not be possible?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

olindeman You could create a calculated column in the 2nd table to determine the "Account" that you want to use...

Account = IF(Table2[Parent Account] = BLANK(), Table2[Account Number], Table2[Parent Account])