Kusto: Do a leftsemi join including columns from right table

Question

I want to lookup values from a different query. I stumpled upon two keywords which may could make sense: join and lookup. leftsemi join looks exactly what I need, but I cannot access columns on the right side. Any other variants that I've tried are adding more rows. The resulting table should not have more entries than FactTable, but can be less in case of null values.

let FactTable=datatable(name:string,timeprofile:string) [
  "Paul", "10:30",
  "Eric", "8:30",
  "Eric", "9:30",
  "Petra", "9:49"
];
let DimTable=datatable(name:string,details:string) [
   "Paul", "+",
   "Eric", "-",
   "Eric", "-",
   "Eric", "-",
   "Lessly", "++",
   "Martha", "+",
   "Martha", "+",
   "Martha", "+"
];
FactTable
| join kind=leftsemi DimTable on name 

But the resulting table is missing details column from DimTable.

Answer 1

You can declare multiple variables within an expression, Measure/Calculated Column/Calculated Table. Just keep in mind they will only be evaluated if refered to, lazy evaluation, and once assigned within it's scope they can't be overwritten.

Example:

My Calculation = 
    var a = 1
    var b = 2
RETURN
    a+b

Your problem might be with the incorrect use of the IF.

https://docs.microsoft.com/pt-pt/dax/if-function-dax

Example:

My Calculation = 
    var a = "Customer 1001"
RETURN
    IF(a = "Customer 1001", "USA" , "Other")