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 experts,
I'm getting this strange error in Excel Power Pivot:
Expressions that yield variant data-type cannot be used to define calculated columns.
Now if I look at the columns that have this error, the formula is simple:
IFERROR([NTK], 0)
However in my case [NTK] column is all empty, and when I check the imported data all columns have "General" type but only NTK has this problem. Other columns have empty cells too so I don't think that's the problem.
I really have no idea what to do about this weird thing, but alas I cannot upload my Excel file, and a dummy file probably won't work out.
Solved! Go to Solution.
Hi @markus_zhang,
This error prompts when there existing two different data types in formula. In your scenario, you used both number value (zero 0 ) and text value ( [NTK] ) in single column.
You can replace the 0 with BLANK() or "" to avoid such an error.
Best regards,
Yuliana Gu
Hi @markus_zhang,
This error prompts when there existing two different data types in formula. In your scenario, you used both number value (zero 0 ) and text value ( [NTK] ) in single column.
You can replace the 0 with BLANK() or "" to avoid such an error.
Best regards,
Yuliana Gu
Hi I figured it out,
=[NTK] works but =IFERROR([NTK], 0) doesn't work, weird...
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |