cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

 

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! 

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: Calculated table with ADDCOLUMNS(SUMMARIZE LASTDATE Problem

hi @mvananaken

 

If you want a table visual with each systemUser and LastDate

 

You can use this:

 

LastDate.png




Lima - Peru
Highlighted
Helper II
Helper II

Re: Calculated table with ADDCOLUMNS(SUMMARIZE LASTDATE Problem

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

Highlighted
Helper III
Helper III

Re: Calculated table with ADDCOLUMNS(SUMMARIZE LASTDATE Problem

Is this what you are looking for ?image.png

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors