Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Experts
I cannot see my error in the following if dax calculated column ...
Measure =
If('Table[Apple] = 1, "Fruit",
If('Table[Apple] = 0 && Table[Value] <> Blank, Table[Value])))
getting an erro rmessage "Expression that yields variant data-type cannot be used to define calculated column"
Solved! Go to Solution.
@Invesco , Try like
Switch(True(),
Table[Apple] = 1, "Fruit",
Table[Apple] = 0 && Table[Value] <> Blank() , Table[Value]& ""
)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.