Relate many to many between two tables

[Syndicate_Admin]

Hello

Let's see if they can help with the following.

I have two tables:

Tabla_vendedores

For each seller there are two rows, because what I want is that from the other table of facturas_vendedores create a new column that is importe=amount*bloc1 / amount*bloc2

To know if it is bloc1 or bloc2 first I want the field facturas_vendedores[family] to be equal to the corresponding row of tabla_vendedores[fam] and then choose bloc1 or bloc2 (the latter would put it manually in the formula or automatically, for now manually)

Table facturas_vendedores

Thank you

[Syndicate_Admin · Accepted solution]

I solved it using dax with calculate and firstnonblank