Forum Discussion
Numbers to Text with IF Statement
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?
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","")))))
4 Replies
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 Anonymous
a possible proposal:
1) convert Num (Percent) column to Text
2) use SEARCH (or FOUND) function in if- statementcomparing text-to-text should be ok
Best regs
