Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose I have the following data:
Company | Update | Person |
A | 10-Oct-2023 | John |
B | 4-Sep-2021 | Lisa |
B | 8-Nov-2019 | Hank |
C | 4-Feb-2022 | Pete |
D | 10-Dec-2022 | Karen |
D | 1-Jan-2020 | Steve |
E | 5-Sep-2023 | Michael |
But I only want to show the most recent update date for each company. So, I want this table.
Company | Update | Person |
A | 10-Oct-2023 | John |
B | 4-Sep-2021 | Lisa |
C | 4-Feb-2022 | Pete |
D | 10-Dec-2022 | Karen |
E | 5-Sep-2023 | Michael |
Ideally, both 'Company' and 'Person' are dimensions, whilst 'Update' is a measure.
How do I get to this result? I can the date to use '=max(update)', but then I don't get a person in the table. I've tried many other functions (firstsortedvalue, aggr, only, distinct) as well, but I haven't solved it.
Person would have to be a measure as well, Something like
Try first
ONLY(Person)
I suspect it will need a set expression to
Only({<Update={"=Max(Update)"}>}Person)
essayez avec un dollar $
{"$(=max(Update))"}
Thanks. This works for a few in my dataset (which is bigger than the one above), but strangely not for most of them.