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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Toll
Helper I
Helper I

Maths equation on columns from multiple tables

Hello,

I wrote a long question before and it seems to have disappeared...

I am trying to perform the following equation:

 

( Table1[Revenue] / Table2[WDIC] ) * Table2[CWDSF] / Table3[Hours]

 

Table1 contains CustomerId and Revenue (whole number)

Table2 is a summarisation of a Calendar table with some extra calculated columns

Table3 contains CustomerId, DoneDate, and Hours (whole number)

 

Table4 is a Customers table with CustomerId and CustomerName

 

Table1 has a 1:1 Relationship with Table4

Calendar has a *:1 Relationship with Table2 (based on a column with "MMMM_YYYY")

Table3 has a *:1 Relationship with Table4 (based on CustomerId)

Table3 has a *:1 Relationship with Calendar (based on Table3[DoneDate] = Calendar[Date]) 

 

Would someone please be able to help me create the following output in a table visualisation? The result column:

 

CustomerIdRevenueSum of HoursWDICCWDSFResult
155000600211252.38
230000400211242.85
320002921123.94

 

This table has a filter so that it will always show the current month (i.e. September 2022)

 

The closest I got returned 100s of rows with each of the CustomerId duplicated multiple times and the result column was duplicated too.

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

Hi @Toll ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hi,

Thanks for your reply

Are you requesting a sample of all the tables? Otherwise, the table in the original question has the sample data and expected outcome.

Yes sample of all tables needed to recreate the issue.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors