Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mrcss23
Advocate IV
Advocate IV

PRODUCT and VLOOKUP in DAX power bi

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!

Captura de ecrã 2022-09-22 183152.png

1 ACCEPTED SOLUTION
mrcss23
Advocate IV
Advocate IV

I just found a way!!!
 
Result = SUMX('Table 1','Tavle1'[VALUE]*RELATED('Table 2'[Rate]))

View solution in original post

3 REPLIES 3
mrcss23
Advocate IV
Advocate IV

I just found a way!!!
 
Result = SUMX('Table 1','Tavle1'[VALUE]*RELATED('Table 2'[Rate]))
Greg_Deckler
Super User
Super User

@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(...),...)


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I know the fuctions but I am not being able to achieve the result. Any suggestion?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors