I have a table and need to group two measures by month based on:
1. Count of orders based on purchase date
2. Sum of sales based on paid date (most of the time they are in the same month, but not always)
Thank you very much,
Kindly post sample data, it will be easy to understand and provide a solution.
Retrieving data ...