Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, i am new to Power Bi.
while using the IF Statement, i am getting an error like this yield variant data-type cannot be used to define calculated columns
Calculation is: IF(AND([Completion Status]="Open",[Status]="MD Ops Review - Delete"),Sheet1[NET_DAY],"")
Can any one help me on this.
Thanks in Advance!
Solved! Go to Solution.
Hi @sureshdam18,
I think you are try to use both number value and text value in one calculate column so power bi can't auto analysis data type of this calculated column.
Maybe you can try to use 0 to replace "" part to keep similar data type or modify the column type to text.
Column= IF ( AND ( [Completion Status] = "Open", [Status] = "MD Ops Review - Delete" ), Sheet1[NET_DAY], 0 )
Regards,
Xiaoxin Sheng
Worked for me , thanks!!
Hi,
I get the same error
I use column as
Count = Var A = calculate (countrows (table name)) Return if (isblank (A),"NA",A)
Thanks
HI to all, may I know what seems to be the problem here?? The format is right but still get this king of error
Hi, I have the same issue but I don't want to replace with zero because I want to have a measure based on that column (i.e. Days of travel CLEAR).
City | Days of travel | Days of travel CLEAR |
London | 20 | =if(City<>"",Days of travel,"") |
-4500 | ||
London | 10 |
Hi @sureshdam18,
I think you are try to use both number value and text value in one calculate column so power bi can't auto analysis data type of this calculated column.
Maybe you can try to use 0 to replace "" part to keep similar data type or modify the column type to text.
Column= IF ( AND ( [Completion Status] = "Open", [Status] = "MD Ops Review - Delete" ), Sheet1[NET_DAY], 0 )
Regards,
Xiaoxin Sheng
so how can i do it ?
Thanks- I had the same issue and it was solved.
Hi,
May I ask how did you solve the issue?
How about my case ?
Please suggest me
[Expressions that yield variant data-type cannot be used to define calculated columns.]
truecondiation = IF(ISM[OData_{CH} Recommend0]=BLANK(),ISM[OData_{RNSP} TSS_x00],ISM[OData_{CH} Recommend0])
Hi,
I get the same error with today(), Any suggestions on how to fix this error?
cDate = IF([SharePointColumnD]="","",
IF([ICColumn]="",NOW(), [ICColumn]))
Hi @Anonymous
Thanks For the Replay,
Issue is Resolved.
Regards,
Suresh
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |