Forum Discussion

antonio_wurth's avatar
antonio_wurth
Icon for Helper I rankHelper I
2 years ago
Solved

add column from not direct linked table

hello  help please i have 2 tables there is no relation between them but i need to add column based on value from table   in file example with more detailed requirements explanation https://1d...
Need Help
  • antonio_wurth's avatar
    antonio_wurth
    2 years ago

    looks i received expected result

    work_hours =
    var p_employee_id = VALUES(dim_clients[main_sales_manger_id])

    return
    sumx(
        FILTER(fact_employees_days_off,
        fact_employees_days_off[employee_id] IN p_employee_id), fact_employees_days_off[day_off])
antonio_wurth's avatar
antonio_wurth
Icon for Helper I rankHelper I
2 years ago

i added formula 

work_hours =
var p_employee_id = MAX(dim_clients[main_sales_manger_id])
RETURN
sumx(
    FILTER(fact_employees_days_off,
    fact_employees_days_off[employee_id] = p_employee_id), fact_employees_days_off[day_off])
   

but not everywhere getting expected result
here an empty value...

 



antonio_wurth's avatar
antonio_wurth
Icon for Helper I rankHelper I
2 years ago

looks i received expected result

work_hours =
var p_employee_id = VALUES(dim_clients[main_sales_manger_id])

return
sumx(
    FILTER(fact_employees_days_off,
    fact_employees_days_off[employee_id] IN p_employee_id), fact_employees_days_off[day_off])