Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I'm trying to re-create the following in Power BI:
SELECT
i.*,
d.[EmployeeID],
d.[LOB]
FROM [dbo].[tblImport] i
LEFT JOIN [dbo].[tblDepartments] d
ON LEFT(i.[Delegate], 4) = d.[EmployeeID]
First, I created a calculated column to get the left 4 characters of the Delegate field, and then the Relationships button to create the relationship. I could not create a relationship because the values in the Delegate field are not unique.
Second, I went to the Query Editor to try to create the LEFT JOIN there. I attempted to add a calculated column to get the left 4 characters of the Delegate field. I received an error. Here is the code I attempted:
Left4 = LEFT('Main Data Source'[Delegate], 4)
What am I doing wrong? Am I attempting something that Power BI was not built to do?
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |