Search code examples
powerbipowerquerym

How can I return my value from a column created a conditional column?

I'm having the following problem, I want to return as a result the value of a column in Power Query but I can't do it.

I need to know how I am able to show as a result the value of the column.

Table.AddColumn(
"Result", each if [Price] > 15 then "[Price] Is greater than 15")

[Price] doesn't show me the value of the column.

Solution

  • You need to convert [Price] to text first:

    Table.AddColumn(
"Result", each if [Price] > 15 then Text.From([Price]) & " Is greater than 15")