Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |