Related tables

[dracul]

I have a problem in powerbi, I need to multiply the value of the table "folha1'hours" by the table "Valor Houras Data 'valor hora", and it has to filter using the "create login name" and "Date" column.

What is the best way?

Best regards

[MattAllington]

Assuming you mean mes[date] when you say date, try this

=sumx(crossjoin(mes,collabor),calculate(sum(folha1[hours]) * SUM(table[valor hora])))

you will have to adjust the formula for the correct table names and column names. Also I don't know if sum is correct, or if you need something else. The general pattern looks like it should work to me however.