Calculated table with ADDCOLUMNS(SUMMARIZE LASTDATE Problem

Question

Hello Folks,&nbsp;I've got a table like this:&nbsp;Sysid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EnddateSystemuser A &nbsp; &nbsp;&nbsp;02-04-2017Systemuser A &nbsp; &nbsp;&nbsp;04-08-2017Systemuser B &nbsp; &nbsp; 05-04-2017Systemuser B &nbsp; &nbsp;&nbsp;08-08-2017&nbsp;Normally I use LASTDATE[Enddate], but instead of filter context this won't work and allexcept didn't result in the correct behaviour.&nbsp;&nbsp;I &nbsp;think I need a calculated table with (Systemuser is unique because 1 Last enddate per user)&nbsp;Sysid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LastdateSystemuser A &nbsp; &nbsp;&nbsp;04-08-2017Systemuser B &nbsp; &nbsp; 08-08-2017&nbsp;&nbsp;I tried something like this, but the concept of the DAX didn't work.&nbsp;Calculated table -&gt;&nbsp;Lastdatetable = ADDCOLUMNS(SUMMARIZE('PIA';PIA[Sysid];LASTDATE(PIA;EndDate) )&nbsp;Anyone ideas?&nbsp;Thank you!&nbsp;

vvelarde · Answer

hi&nbsp;mvananaken&nbsp;If you want a table visual with each systemUser and LastDate&nbsp;You can use this:&nbsp;

mvananaken · Answer

Hello&nbsp;Vvelarde,&nbsp;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.&nbsp;Any idea to achieve this?&nbsp;Ty!,&nbsp;Kind Regards, Marco

abhishekpati86 · Answer

Is this what you are looking for ?&nbsp;

Forum Discussion

Calculated table with ADDCOLUMNS(SUMMARIZE LASTDATE Problem

3 Replies

Related content

AddColumns with Summarize

returning blank values when using SUMMARIZE and ADDCOLUMNS

Using ADDCOLUMNS instead of SUMMARIZE

RANKX with SUMMARIZE AND ADDCOLUMNS

summarize vs addcolumn