Trial Balance - Values on Debit or Credit Column

DAX DAX Calculations
1

I am working on recreating a Trial Balance (and other Financial reports) in Power BI.

image
image754×252 35.2 KB

What I need is to include my “negative values” in my Debit Column and my"positive Values".

I was trying to achieve using Switch True logic, but I can not make it work!

image

I can classify values in Debit Credit, but I can not put them in the right column

image

Attached is my pbix.

Help is much appreciated.

Thanks,
Foro Trial Balance Report .pbix (908.7 KB)

1 Like
2

Hello @ezenunez,

Thank You for posting your query onto the Forum.

Well, you just have to create a column under the table “Balance Sheet Data”. Below is the formula using “SWITCH( TRUE() )” statement provided for the reference -

Debit-Credit Status = 
SWITCH( TRUE() , 
    'Balance Sheet Data'[Balance Sheet Type] = "Assets" , "Debit" , 
    'Balance Sheet Data'[Balance Sheet Type] = "Liabilities" , "Credit" ,
    'Balance Sheet Data'[Balance Sheet Type] = "Owner's Equity" , "Credit" , 
BLANK() )

Once you create this column, just drag it under the “Columns” section of the Matrix visual and you’ll get the results. Below is the screenshot of the final results provided for the reference -

Final Results
Final Results633×595 15.4 KB

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Important Note: Since content is created from an educational point of view, the data is of the fictitious nature and therefore the total of trial balance i.e. Debits and Credit will not be equal.

Thanks and Warm Regards,
Harsh

Foro Trial Balance Report - Harsh.pbix (906.0 KB)

3

Thanks Harsh,
That will help me a lot at the moment of Creating the blance sheet you have well pointed the Assets on the Credits and liabilitys and , liability / Owners on the Debit…

At the tria balance, I would like to locate in the column according to Positive / Negative Values, where (+) goes to Credit and (-) to Debit and the columns should balance.

Sometimes, accounts are “upside down”!

Any other way to achive this ?
Thanks again!

4

Hello @ezenunez,

Well, as suggested above, in this case, the column of Debit will not tally with the Credit column since data is of fictitious nature and created from an educational perspective.

But as you suggested, that in general (+) should be termed as Credit and (-) should be termed as Debit, in that case, first you’ll definitely have to ensure that all positive (+) numbers are only and only Credit related and all negative (-) numbers are Debit related. If this is the situation then you can simply apply the “SWITCH( TRUE() )” statement over the number/figures/amount column rather than applying it over Balance Sheet Type column (which was done above) and state the condition as (+) numbers equals Credit and (-) numbers equals Debit. And you’ll get the results accordingly.

Hoping you find this useful and helpful. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

5

Thanks a lot Harsh! Have a great friday.
Cheers, Ezequiel

6

Hello @ezenunez,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh