Forum Discussion
Distinct Count Based on Week Number Before Selected Week
Hello, I have table consist of CustomerID, TransactionDate, WeekofYear. I want to DISTINCTCOUNT the customer based on 6 weeks before current week and display it in column chart. So if the column ch...
Hi hani1711
Please refer to the linked video:
https://www.youtube.com/watch?v=0enQCIWCSUE
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.