So I have 2 tables and using some formula in the calculated columns section i want to create a new column. It looks like this:
reference | some string | datetime
r1 | aa | 29/11/2021
r1 | bb | 25/11/2021
r2 | cc | 28/11/2021
r3 | ab | 28/11/2021
r3 | ab | 29/11/2021
For table 2 I want to add a calculated column that includes the most recent date for each reference. It would look like this:
reference | calculated max date
r1 | 29/11/2021
r2 | 28/11/2021
r3 | 29/11/2021
I have tried to program it like this:
ServiceTickets[ServiceTicketStateId] = 4,
Calculate(MAX(Mail[DateTimeSent]), Mail[Meldingsnummer] = ServiceTickets[Reference])
This returns difficulties with the filter expression as it does not allow different tables to be used. How can I solve this? Thanks in advance!
Go to Solution.
Hi @MagisKoen ,
Please find the solution below,
Please like and mark it as a solution if it give right answer to you. thanks
View solution in original post
Thank you a lot Aburar_123, I did need to put in a Lookupvalue to transpose the data to the other table but this works!
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!