if text.contains then get value from another column

[sullynivek]

Hi All,

I am trying to perform a simple excel look-up but using query editor via Power BI (New to both). I have a column named 'Hours_type' and another called 'hrs' and then a new column just named 'New Column' (for now). What I want is the following:

New Column = if text.contains[Hours_type] 'R' then [hrs] (value) else blank cell

Can an expert in Power BI help me please.

Kevin

[MarcelBeug · Accepted solution]

No need for an expert, as this is quite basic, but still ...

In the query editor you can add a custom column with a formula as shown in the video (from Power Query in Excel, but similar in the query editor in Power BI).

Note that Power Query is case sensitive, so it only checks for uppercase "R".