DAX- largest value from coloumn and search in different table

[Anonymous]

Dear Community,

i need your help with the creation of a DAX-programming for Microsoft PowerBi.

In the "Project_No" column there are many entries with the associated "Project_Step" column.

I need every single entry in "Project_No" with the corresponding highest entry in "Project_Step" (It can also be that 000 is the highest value).

Then i have to check if the highest combination of Project_No & Project_Step from Table 1 is in the Project coloumn in Table 2.

If it is, i don´t need it.

If it doesn´t, i need the correspondig "value".

Actually "Value" only occourse in the highest "Project_Step". Only in exceptional cases also in lower values and i have to add these.

I already have the following formula to find the highest combination of "Project_No" and "Project_Step".

= calculate(max(Table[Project_Step]), filter(Table, Table[Project_Step] = calculate(max(Table[Project_Step]), allexcept(Table, Table[Project_No]))) )

I would be very grateful if you can help me, i despair ! Thank you so much

[amitchandak]

@Anonymous , A new column in table 2

new column =
var _max = maxx(filter(Table1, Table2[project_no] = Table1[project_no] ), Table1[project_step])
return
maxx(filter(Table1, Table2[project_no] = Table1[project_no] && Table1[project_step] = _max), Table1[value])

[Anonymous]

Hi @amitchandak 

The function works but unfortunately it gives me many of the same values ​​from table 1 and table 2. I don't need the values ​​from the same Project from  table 1 and table 2.