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.
Hi. I have imported two tables in power BI.
Table 1 has values for several employes.
Table 2 has a rate for each employee.
I would like to SUM the result of product VALUE (table 1)* Rspective RATE (table 2).
In Excel I use PRODUCT and VLOOKUP,
The final result should be total of that column (126, 91 in the example below)
What should be the DAX in POWER BI?
Thank you!
Solved! Go to Solution.
@mrcss23 There is an equivalent PRODUCT function in DAX, although you can just use *. Also there is PRODUCTX. For VLOOKUP either use LOOKUPVALUE or MAXX(FILTER(...),...)
I know the fuctions but I am not being able to achieve the result. Any suggestion?
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 |
---|---|
44 | |
21 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |