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
lelorenzi
Frequent Visitor

Lookup from different tables and columns indexing in a new table

Hi all,

I'm trying to combine the values of two different tables in a new table:

lelorenzi_1-1697552055837.png

 

 

The first table is the Index calendar, where I want to have the # of created (according to the created week) and # of purchases (according to the purchased week).

I cant use relations, because created and purchased weeks are different.

These two # columns are running totals.

I tried to created a calculated column in the table A, but I cant use the LOOKUP as the running totals are measures and not columns.

 

Does anyone has any idea how to solve this?

1 REPLY 1
marcelsmaglhaes
Super User
Super User

Hey @lelorenzi ,


You should try Mergie Queries in Power Query. Take a look in the video: Power BI Tutorial: Merge Queries in Power Query - YouTube

 

If this posts felps, please mark as solved.
Regards,
Marcel


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



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.