Forum Discussion
Helper IIINeed help - IF condition - dax measure
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:
5 Replies
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!
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.
