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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hammad_ali
Regular Visitor

Multiply two columns in different tables by most recent date

Hi,

 

I'm having trouble multiplying two colums in two tables to get the most recent value.

The tables look like this:

 

table1  
   
uidTickRefCount
1AB110
2AB420
3XY25
4XY15

 

table2   
    
uidDateTickRefValue
131/01/2019AB1100
231/01/2019AB4200
330/06/2019XY210
430/06/2019XY150
530/06/2019AB1150
531/07/2019XY220

 

The TickRef in both tables are related and is one to many, table2 having many entries. What I want to achieve is to multiply sum of Count in table1 with the value from table2 with the most recent date.

Expected result should be like this:

 

Expected Result   
    
TickRefSum CountLatest ValueProduct
AB1101501500
AB4202004000
XY2520100
XY1550250

 

I can't seem to figure this one. Please help or share a link with solution to a similar problem.

 

Thanks

1 ACCEPTED SOLUTION
venal
Memorable Member
Memorable Member

Hammed_Ali.JPG

Hammed_Ali-2.JPG

Can you please refer the above steps to get the expected result with out DAX.

View solution in original post

2 REPLIES 2
venal
Memorable Member
Memorable Member

Hammed_Ali.JPG

Hammed_Ali-2.JPG

Can you please refer the above steps to get the expected result with out DAX.

amitchandak
Super User
Super User

I think summarizing data across table worth exploring 

https://community.powerbi.com/t5/Desktop/Summarize-multiple-tables-in-DAX/td-p/642693

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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