Lookup from different tables and columns indexing in a new table

[lelorenzi]

Hi all,

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

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?

[marcelsmaglhaes]

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