Forum Discussion

mvananaken's avatar
mvananaken
Icon for Helper II rankHelper II
9 years ago

Calculated table with ADDCOLUMNS(SUMMARIZE LASTDATE Problem

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   ...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

hi mvananaken

 

If you want a table visual with each systemUser and LastDate

 

You can use this:

 

mvananaken's avatar
mvananaken
Icon for Helper II rankHelper II
9 years ago

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's avatar
    abhishekpati86
    Icon for Helper III rankHelper III
    8 years ago

    Is this what you are looking for ?