Forum Discussion
bolabuga
8 years agoHelper V
[ Retrieving the Last Date ]
Hello everyone, I have the following scenario: Revenue and Service tables don’t have a relationship (i don’t know how to handle it, it would be a many to many relationship based on client colum...
v-yulgu-msft
8 years agoMicrosoft Employee
Hi bolabuga,
Could you please provide detailed sample data? It would be helpful for us to better understand your scenario and test for you.
Regards,
Yuliana Gu
- bolabuga8 years agoHelper V
- bolabuga8 years agoHelper V
Hi v-yulgu,
I did a test database and replicated the scenario that some insights would be great!!!
https://drive.google.com/open?id=0B8Aq8DhGApJqWDZlLTdQYnFibDQ
- Zubair_Muhammad8 years agoCommunity Champion
Hi bolabuga
Try replacing SUMX with MAXX