I have a table called fact_ActualsOrders_ES. It is the actual cost to hit a project. It is related to dim_cost_element table via a relationship.
I want to filter the ActualsOrders_ES table based on a field in dim_cost_element called cost_element_text. I only want records in the fact table where cost_element_text DOES NOT BEGIN WITH "Settled".
I tried created a calculated column in fact_ActualsOrders_ES by putting in this formula:
=FILTER(fact_ActualsOrders_ES,LEFT(Related(dim_cost_element[cost_element_text]), 7) <> "Settled")
I got this error:
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
What am I doing wrong?
I want to filter the ActualsOrders_ES table based on a field in dim_cost_element called cost_element_text. I only want records in the fact table where cost_element_text DOES NOT BEGIN WITH "Settled".
I tried created a calculated column in fact_ActualsOrders_ES by putting in this formula:
=FILTER(fact_ActualsOrders_ES,LEFT(Related(dim_cost_element[cost_element_text]), 7) <> "Settled")
I got this error:
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
What am I doing wrong?
