Forum Discussion
bolabuga
Helper V
8 years ago[ 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
Microsoft Employee
8 years agoHi 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
Helper V
8 years ago
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 ago
Community Champion
Hi bolabuga
Try replacing SUMX with MAXX