IF condition statement - dax measure

DAX DAX Calculations
1

Hi PBI friends,

I have a table with two columns named Table[Current Asset] and Table[Current Liabilities] and I wanted to make a dax measure where:

1.) if there were negative values inputted on the table[current asset], it will be then transferred to table[current liabilities], else it will stay at table[current asset]

2.) if there were negative values inputted on the table[current liabilities], it will be then transferred to table[current asset], else it will stay at table[current liabilities].

See below-desired output:

rbalza_0-1623630350937.png

2

Hi @ronald_balza ,

If you would have a source data table like below:
image

and the negative asset cq liability should be transferred to the other side, remaining its negative value,
a possible solution is
Assets Liab transferred.pbix (49.1 KB)

  1. creating 2 basic measures, sum current assets and sum current liab.
  2. creating 2 additional measures which calculates the required amounts, like
Calc New Assets = CALCULATE( [Net Assets], FILTER( BaseTable, [Net Assets] >= 0 ))  
                           + CALCULATE( [Net Liab], FILTER( BaseTable, [Net Liab] < 0))

As you want both columns adjusted, one measure in my opinion is not enough, you need two measures to be able to recalculate the current assets and current liabilities.

Which results in the following outcome :

image
image701×169 6.61 KB

Probably accounting wise the negative assets values should become positive liability values and vice versa (instead of remaining negative on both sides )?

Is this a solution which will work for you ?
Kind regards, DeltaSelect

2 Likes
3

Hi there
I know what you trying to do there but very careful concerning balance (negative/positive) of certain accounts. Like accumulated depreciation is a negative balance but its part of the asset side not a liability side for the balance sheet.

I know that liability accounts can go into positive amount but you need to make sure its on the right side of the balance sheet.

Positive amount on the liability side should be investigate.

Just be careful you may run into trouble later.

thanks
Keith

3 Likes
4

Hi @ronald_balza ,

I’m not sure why you marked my message as a solution to it. I didn’t provide dax solution to you. I just wanted to let you know just be careful.

thanks
Keith

1 Like
5

Hi @Keith,

Misclicked. Thanks for the advice :wink:

1 Like
6

Hi @deltaselect,

Yeah you are right. negative asset becomes positive liability vice versa.

7

@ronald_balza
It’s all good :slight_smile:

1 Like
8

Do you have some sort of a tutorial here at eDNA specifically for accounting? Would love to dive into it if any :blush:

9

@ronald_balza ,
i’ve worked in accounting/finance area for years. to learn about assets and liability and capital area of the balance sheet you can research on internet. you can also search accounting in the search bar to see what come up too.

i don’t know what area of specialization your have but you just need to careful on classification of your accounts.

thanks
keith

10

Hi @ronald_balza, did the response provided by @Keith help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!