Forum Discussion
summarizing data in measure with date dynamically
Hello, I am working on creating measure to identify the customers who have bought products in retail or digital or both retail and digital daily, weekly or yearly dynamically. below is the sa...
thank you for the response but I am looking for 3 customer type
1. who bought only in retail
2. who bought only in online
3. who bought in both retail and online
the result for daily should be like below:
| datetimeSales | CustomerType | Total Sales |
| 01-Oct-20 | Both | 30 |
| 02-Oct-20 | Retail | 5 |
| 03-Oct-20 | Online | 40 |
| 04-Oct-20 | Online | 20 |
| 05-Oct-20 | Online | 10 |
| 06-Oct-20 | Retail | 5 |
similar result should be for week/Month/year where datetimeSales will be replaced with week number/Month number and year.