[ power BI ] quantity to sales with different price list per customer

[LMDV]

Hi Team,

I'm new to DAX and was wondering what's the best way to accomplish the below.

What DAX code should I use?

Thank you!

@BA_Pete @m_dekorte I'd appreciate your help please?

[qqqqqwwwweeerrr · Accepted solution]

Hi @LMDV 
you can acheive this by creating two new columns in both the table

Concat table = input_1[customer] & "-" & input_1[product] in table one

Concat table = input_2[customer] & "-" & input_2[product] in table 2

then make a connect between them 

then use this dax again for creating enw column in table one

Price = RELATED(input_2[Price])

then caculate sales 

Sales = input_1[Qty Sold]*input_1[Price]

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[LMDV]

that worked, thank you! @qqqqqwwwweeerrr 

question -- from a processing runtime point of view, is the above process using DAX faster than using Merge in PowerQuery?