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.
Hello,
I'm using a matrix and trying to show percentage growth year over year. I've tried using an IF expression to correct, but it only fixes one of the 2 possible scenarios. I need the result to either by positive 100% if there is no value for the previous year, or -100% if there is no value for the current year.
Any suggestions?
Solved! Go to Solution.
Hi @Anonymous ,
Wrap the measure or column with an Nested If measure = IF(ISBLANK(table[x]),100%,IF(ISBLANK(table[y]), -100%, [your measure])
This should give you the three outcomes that you are looking to see.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
Wrap the measure or column with an Nested If measure = IF(ISBLANK(table[x]),100%,IF(ISBLANK(table[y]), -100%, [your measure])
This should give you the three outcomes that you are looking to see.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
You are welcome! Is NPV Net Present Value?
Proud to be a Super User!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |