Forum Discussion
Getting a unique value of the latest date
Hi Petri
Do you want to put custom1, custom2, etc. in different columns of a single row? Something like below?
custom1 = #table({"Latest Date 1", "Latest Date 2"}, {{List.Max(ATable[Date]), List.Max(BTable[Date])}}) in custom1If it's not what you want, can you provide the expected table you want to get with some sample data?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you! This indeed makes it easier and avoids navigating to the table and field first. I even managed to get the values from several tables:
custom1 = #table({"Latest Date"},{{List.Max(ATable[Date])}}),
custom2 = #table({"Latest Date"},{{List.Max(BTable[Date])}})
in
custom1
...althoug I still struggle how to get the custom1, custom2, etc. in different columns.
Community SupportHi Petri
Do you want to put custom1, custom2, etc. in different columns of a single row? Something like below?
custom1 = #table({"Latest Date 1", "Latest Date 2"}, {{List.Max(ATable[Date]), List.Max(BTable[Date])}})
in
custom1
If it's not what you want, can you provide the expected table you want to get with some sample data?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thanks a lot for your quick reply - this was exactly what I was after.