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.
I am using the below formula to generate a computed column
Organization =
IF(ISBLANK(ColumnA),
IF(ISBLANK(ColumnB),
ColumnC,
ColumnB),
ColumnA)
All the three columns (ColumnA, ColumnB and ColumnC) are of text datatypes. But I am seeing the error
expressions that yield variant data-type cannot be used to define computed columns
with the computed column. Any idea what could be the reason?
Solved! Go to Solution.
Thanks for the reply but I figured out the root cause for this. It was because of some null values in the incoming data. The preview was misleading me. Once I refreshed all the datasets I stumbled upon the rootcause.
Can you post some sample raw data so we can test out? Your code seems correct, so there are probably external factors at work...
Proud to give back to the community!
Thank You!
Thanks for the reply but I figured out the root cause for this. It was because of some null values in the incoming data. The preview was misleading me. Once I refreshed all the datasets I stumbled upon the rootcause.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |