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
bolabuga
8 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