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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mcmum01
Helper I
Helper I

Multiply two values from the same table

Hi all

 

I have a table with transactions in it as well as well as rate per transaction. I would like to write a dax formula that finds the rate for the month and for the customer, and multiple it together to get to revenue. I could separate the transactions and rates into 2 different tables, but wanted to try something different. Example: ACME01, 1/1/21 = 100 * 10 = 1000. ACME01, 2/1/21 = 110 * 20 = 2200, etc. Is there any easy way to do this or should I just separate the rates and transactions into 2 tables?

 

GP Vendor ID

MeasureValueMonth
ACME01transactions1001/1/2021
ACME01rate101/1/2021
ACME01transactions1102/1/2021
ACME01rate202/1/2021
ABCE01transactions1153/1/2021
ABCE01rate303/1/2021
2 REPLIES 2
Jihwan_Kim
Super User
Super User

Picture1.png

 

Result measure : =
CALCULATE ( SUM ( Data[Value] ), MeasureTable[Measure] = "transactions" )
* CALCULATE ( SUM ( Data[Value] ), MeasureTable[Measure] = "rate" )
 
 
 
 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


I tried that and I got some really big numbers. I gave you a small sample of a larger table. Would it be different if there were multiple GP Vendor IDs in a month? Here is an example:

 

GP Vendor IDStoreMeasureValueMonth
ACME011transactions1001/1/2021
ACME011rate101/1/2021
ACME012transactions1101/1/2021
ACME012rate201/1/2021
ACME013transactions1151/1/2021
ACME013rate301/1/2021

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.