Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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".
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".
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |