The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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]& ""
)
User | Count |
---|---|
69 | |
64 | |
62 | |
55 | |
28 |
User | Count |
---|---|
184 | |
82 | |
65 | |
48 | |
38 |