Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
hi @mvananaken
If you want a table visual with each systemUser and LastDate
You can use this:
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
Is this what you are looking for ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |