Forum Discussion
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
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
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
3 Replies
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
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).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
