Forum Discussion

AndradeRobson's avatar
AndradeRobson
Helper II
2 years ago
Solved

Help me Power Query - Power BI

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...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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's avatar
    AndradeRobson
    Helper II
    2 years ago

    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