Forum Discussion
Solved
Left Outer Join/Left Four Characters
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.[EmployeeI...
- Hi imani_tech,
In the query editor the language is not DAX is M so the formulas are different you need to yse the following formula:
Text.Start([Delegate], 4)
Be aware that in power query the formulas are case sensitive so you need yo put it with the caps in first letter of each word.
Regards
MFelix
MFelix
Super User
Super UserHi imani_tech,
In the query editor the language is not DAX is M so the formulas are different you need to yse the following formula:
Text.Start([Delegate], 4)
Be aware that in power query the formulas are case sensitive so you need yo put it with the caps in first letter of each word.
Regards
MFelix
In the query editor the language is not DAX is M so the formulas are different you need to yse the following formula:
Text.Start([Delegate], 4)
Be aware that in power query the formulas are case sensitive so you need yo put it with the caps in first letter of each word.
Regards
MFelix