Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |