Forum Discussion
AdministratorBring maximum value according to another row
Hello everyone
I tell you that I have a model which reads weekly excel files, so the information is changing
the problem I have is as follows
This changes by week, suppose the first value is from week 1 and I need to read the last one that is from week 5. create a function that will bring me the most current week but still when trying to use the VLOOKUPVALUE function but it tells me that several values are provided where only one was expected and it is logical since there are 2 different values, attached referential image of the values (TS Port1)
How can I read them?
Thank you very much in advance ❤️
Hi Syndicate_Admin ,
Use calculate max instead of lookupvalue
column = calculate(max(value),filter(...))Best Regards,
Jay
1 Reply
Hi Syndicate_Admin ,
Use calculate max instead of lookupvalue
column = calculate(max(value),filter(...))Best Regards,
Jay