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 all,
I keep getting this NaN error for this statement, and I am not sure why
I am trying to show growth % from 2019 Vol to 2020 Vol by doing 2020 vol minus 2019 vol, then divide that by 2019 vol to get the %
TIA!!
Solved! Go to Solution.
Hey @Anonymous ,
what exactly do you want to do?
For me it looks like these are all calculated columns. Calculated column are statis, that means they are created when the file is loaded and won't change anymore afterwards. For example when you use a slicer, it won't change the content of the column.
In your case the new calculated column [Vol Growth '19-'20] will perform the operation line by line once the file is loaded. I'm not really sure if you want that.
Usually you want the whole thing to be interactive. For that you would use a measure. If you create a measure the columns need aggregation. So as a measure you would write:
Vol Growth '19-'20 = ( SUM( 'Img Div_Img'[2020 Vol]) - SUM( 'Img Div_Img'[2019 Vol]) ) / SUM( 'Img Div_Img'[2019 Vol])
Hey @Anonymous ,
what exactly do you want to do?
For me it looks like these are all calculated columns. Calculated column are statis, that means they are created when the file is loaded and won't change anymore afterwards. For example when you use a slicer, it won't change the content of the column.
In your case the new calculated column [Vol Growth '19-'20] will perform the operation line by line once the file is loaded. I'm not really sure if you want that.
Usually you want the whole thing to be interactive. For that you would use a measure. If you create a measure the columns need aggregation. So as a measure you would write:
Vol Growth '19-'20 = ( SUM( 'Img Div_Img'[2020 Vol]) - SUM( 'Img Div_Img'[2019 Vol]) ) / SUM( 'Img Div_Img'[2019 Vol])
@Anonymous , Try
Vol Growth '19-'20 = divide('Img Div_Img'[2020 Vol]-'Img Div_Img'[2019 Vol],'Img Div_Img'[2019 Vol])
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |