USE LOOKUPVALUE TO TAKE DATA FROM TABLE WITH DUPLICATES

[pezakas]

Hello community, 
i have 2 tables ALPHA & BETA.
ALPHA hosts projects and each line represent a single update in a project, thus this table has duplicate project codes.
BETA hosts unique projects.

All i want is to fill BETA table with the data from ALPHA table and i want for each project code to take the line with highest cycle and as a result the latest updated date and fill it in BETA.

ALPHA TABLE

BETA TABLE 

Thanks in advance

[NickolajJessen]

Is the BETA table how you want the data to look? Or is that how the data looks now?

Are you looking to do it as calculated columns or is a measure also an option?

[pezakas]

the BETA exists already. i want to add new columns "Cycle", "Effort" & "Latest Update" with info from ALPHA so the table looks like the picture i posted.
I would prefer as calculated column if possible.

[NickolajJessen · Accepted solution]

Well, you could make an additionaly column, that indicates the latest cycle in the ALPHA TABLE as so:

In the BETA table you can add a coulumn, that does a lookup on the project AND where it says "latest" as so:

Repeat this last step for the other columns you need.

[pezakas]

Thank you!