Help me Power Query - Power BI

[AndradeRobson]

Dear all, good afternoon!

Can you help me.

Within Power Query I have an accounting chart of accounts for three companies.

CT1_BRANCH      CT1_ACCOUNT
01                         100000000
02                         100000000
03                         1000000000

My goal is to create a custom column like this:

CT1_BRANCH         CT1_ACCOUNT          Marscara
01                           100000000                 1.00.00.00.00
02                           100000000                 1.00.00.00.00
03                           1000000000                1.0.00.00.0000

IF 01 equals 1.00.00.00.00
IF 02 equals 1.00.00.00.00
IF 03 equals 1.0.00.00.0000

Could anyone help me convert this within the Power BI Power Query.

Att.

Robson

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[Ritaf1983]

Hi @AndradeRobson 
The logic should be based on CT1_BRANCH or on CT1_ACCOUNT?
The result should be a text data type? ( it doesn't seem like decimal). 

[AndradeRobson]

That. Today the column is already in Text and the result will be text.

This table is from a database and the format of the numbers is without periods or separators.

Note in this same table there are three charts of accounts.

01 - Company A - Account structure 100000000 | 1.00.00.00.00
02 - Company B - Structure of accounting account 100000000 | 1.00.00.00.00
03 - Company C - Structure of accounting account 1000000000 | 1.0.00.00.0000