Need help - IF condition - dax measure

[rbalza]

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:

[Anonymous]

Hello @rbalza 
In this case, the calculated column will be the better option.
Please check the link.

[Anonymous]

Hello @rbalza 
You can create a calculated column and use in your visual.
Conditioning =
IF (
table[current asset] < 0,
table[current liabilities],
IF ( table[current liabilities] < 0, table[current asset] )
)

[rbalza]

Hi @Anonymous , thanks for taking the time on this. Was it the same measure if I use it on DAX? Thanks a lot!

[Anonymous]

Hello @rbalza 
Nope. You have to use VALUES to store the field values. If you need further help please share your data in a table format with the expected output after removing the sensitive information.

[rbalza]

Hi TarunSharma, please find attached sampledata link https://www.dropbox.com/scl/fi/ymijxgkdbdqt8gzvut3q5/SampleData.xlsx?dl=0&rlkey=xxgmxsh13sm3rtojwndv...