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.
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".
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |