Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |