Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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] )
)
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.
Hi TarunSharma, please find attached sampledata link https://www.dropbox.com/scl/fi/ymijxgkdbdqt8gzvut3q5/SampleData.xlsx?dl=0&rlkey=xxgmxsh13sm3rtojwndv...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |