Forum Discussion

dracul's avatar
dracul
Regular Visitor
9 years ago

Related tables

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

1 Reply

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago

    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.