topic Re: Need help - IF condition - dax measure in DAX Commands and Tips

Need help - IF condition - dax measure

rbalza — Mon, 14 Jun 2021 00:26:22 GMT

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:

Re: Need help - IF condition - dax measure

Anonymous — Mon, 14 Jun 2021 04:55:38 GMT

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] )
)

Re: Need help - IF condition - dax measure

rbalza — Mon, 14 Jun 2021 04:57:07 GMT

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

Re: Need help - IF condition - dax measure

Anonymous — Mon, 14 Jun 2021 05:10:40 GMT

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.

Re: Need help - IF condition - dax measure

rbalza — Mon, 14 Jun 2021 05:46:56 GMT

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

Re: Need help - IF condition - dax measure

Anonymous — Mon, 14 Jun 2021 06:52:43 GMT

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