reclassified chart of accounts

[powerbricco]

Dear All,

In my model I have 3 tables.

Table 1: "Chart of Accounts" table which is approx as follows:

Account Code	Group_01	Group_02	Reclassification Code_Debit	Reclassification Code_Credit
02529	Balance Sheet	Assets	003
02213	Balance Sheet	Liabilities	00112	00011
02643	Income Statement	Costs		0005
02642	Income Statement	Revenues	1534	5236

Table 2: "Reclassification" table which is approx as follows:

Description	Reclassification Code
Credits	003
Credit Note	00112
Bank debts	00011
Costs of sales	0005
Other revenues	1534

Table 3: "Journal" table which is approx as follows:

Account Code	Balance
02529	€ 1.000
02213	- € 2.500
02643	- € 5.000
02642	€ 500

Table 1 is linked to table 3 by Account Code.

How can I relate Table 2 to Table 3 so I can have my reclassified chart of accounts?

Thing is: depending on the balance of each account code (positive or negative), reclassification code may change.

Thanks for your kind suggestions

[v-jialongy-msft]

Hi @powerbricco 

What is the specific logic of your reclassification code? I believe you can achieve this by writing DAX instead of linking two unrelated tables.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerbricco]

Dear @v-jialongy-msft , i thought about this. I believe i can do as follows:

in my chart of accounts table (Table-1), i should create a new column which logic is:

- if SUM(Balance) is > 0, then Reclassification Code_Debit, else Reclassification Code_Credit).

I don't know if I can use a measure or a calculation like SUM(Balance) to create this new column...

[lbendlin]

Please show the expected outcome based on the sample data you provided.

[powerbricco]

Dear @lbendlin , i thought about this. I believe i can do as follows:

in my chart of accounts table (Table-1), i should create a new column which logic is:

- if SUM(Balance) is > 0, then Reclassification Code_Debit, else Reclassification Code_Credit).

I don't know if I can use a measure or a calculation like SUM(Balance) to create this new column...

[lbendlin]

No, you cannot meaningfully create columns from measures.