Add rows to table when merge and no coincidence

[ifritponyboy]

Hello community!

I am trying to add rows if there is no coincidence, like this:

Table 1:

CompanyCode (if it is null or text "All" add as many rows as companies are in table 2)

Account

CompanyCode-Account

Table 2:

CompanyCode

CompanyDescription

Table 3 data:

CompanyCode

Account

Amount

CompanyCode-Account (connect to table 1)

I want to classify wiht the table 1 data in table 3. For example;: in table 1 it appears companycode 1 and account 57 and description "Bank". Then I would have 1-57 and Bank. If there is no company code I would have all the companycodes (for example from 1 to 50) and account 57 and description bank.

Could you help me? Thank you very much in advance. I am trying to make my way in pbi.

[Jimmy801]

Hello @ifritponyboy 

is help still needed?

Jimmy

[v-frfei-msft]

Hi @ifritponyboy ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Jimmy801]

Hello @ifritponyboy 

It's really difficult to help if the description its like this.

Could you please post an example of table 1 to 3 and the exact output you need with description of the rules to apply.

Jimmy