How to create a Custom Column or New Table based with multiple Column condition

Hi buddy,

well, this is happening because you have one date being repeted, so you need something like "index column".

I create one column called "KEY" it would serve to resolve your problem, here goes the steps.

i recreate the table, now only using the summerize for column "Project":

Table = SUMMARIZE(Table1;Table1[Project])

 

 

 

 

 

Create those 2 columns:

last date = CALCULATE(LASTDATE(Table1[Date]);FILTER(Table1;Table1[Project]='Table'[Project]))

Key = CONCATENATE('Table'[Project];'Table'[last date])

 

 

 

 

 

 

Create on the original table this column to be referenced:

Key = CONCATENATE(Table1[Project];Table1[Date])

 

 

 

 

Those "key" columns you can "hide in the report view" so do impact happens.

 

Now you can access the Name column, like this:

Column = LOOKUPVALUE(Table1[Name];Table1[Key];'Table'[Key])

 

 

 

 

 

This should do the trick,

Also, sorry my bad english, it's not my native language.

 

Any questions, ask ;)