Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am currently using a calculation to determine % of Inventory Remaining.
I would like to use an "IF" Statement to convert this calculation to "Plain Text" -
i.e. 100% = "SOLD OUT"
The challenge I am having is that If statements don't allow you to convert numbers to text:
DAX comparison operations do not support comparing values of type Number with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
Any thoughts how I can convert the calc and translate as text?
Solved! Go to Solution.
Have you tried using SWITCH in a new column or a measure?
[Measure] = your calculation
%toText = SWITCH([Measure], 1, "Sold Out", "")
%toTextNested = SWITCH([Measure],1,"In stock", (SWITCH([Measure],0,"Sold out", (SWITCH([Measure],.5,"Low","")))))
Have you tried using SWITCH in a new column or a measure?
[Measure] = your calculation
%toText = SWITCH([Measure], 1, "Sold Out", "")
%toTextNested = SWITCH([Measure],1,"In stock", (SWITCH([Measure],0,"Sold out", (SWITCH([Measure],.5,"Low","")))))
Hi @irnm8dn
a possible proposal:
1) convert Num (Percent) column to Text
2) use SEARCH (or FOUND) function in if- statement
comparing text-to-text should be ok
Best regs
I cannot convert the percent to text, it is a calc - so that options is disabled.
Any other thoughts?
can you create a second column as "text description" of the first, numeric column?
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |