Calculated table with ADDCOLUMNS(SUMMARIZE LASTDATE Problem

[mvananaken]

Hello Folks,

I've got a table like this:

Sysid                 Enddate

Systemuser A     02-04-2017

Systemuser A     04-08-2017

Systemuser B     05-04-2017

Systemuser B     08-08-2017

Normally I use LASTDATE[Enddate], but instead of filter context this won't work and allexcept didn't result in the correct behaviour. 

I  think I need a calculated table with (Systemuser is unique because 1 Last enddate per user)

Sysid                 Lastdate

Systemuser A     04-08-2017

Systemuser B     08-08-2017

 I tried something like this, but the concept of the DAX didn't work. 

Calculated table -> Lastdatetable = ADDCOLUMNS(SUMMARIZE('PIA';PIA[Sysid];LASTDATE(PIA;EndDate) )

Anyone ideas?

Thank you! 

[Vvelarde]

hi @mvananaken

If you want a table visual with each systemUser and LastDate

You can use this:

[mvananaken]

Hello @Vvelarde,

Thanks for reply. But I really need a "calculated table". The discribed structure is a simplification.

Instead of complex relationships a simple LASTDATE(table;column) didn't work, also with ALLEXCEPT didn't reach my goal.

Any idea to achieve this?

Ty!,

Kind Regards, Marco

[abhishekpati86]

Is this what you are looking for ?