cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

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","")))))

View solution in original post

4 REPLIES 4
Highlighted
Resolver III
Resolver III

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

Highlighted

@McCow

 

I cannot convert the percent to text, it is a calc - so that options is disabled.

 

Any other thoughts?

Highlighted

@irnm8dn

can you create a second column as "text description" of the first, numeric column? 

Highlighted
Advocate I
Advocate I

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","")))))

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors