Forum Discussion
schoden
Post Partisan
5 years agoContinous Year
Hi Community, How can I check if a customer year of transaction is continous or not. In the table, the customer A is not continous as 2018 transaction is missed. I have calender table and c...
- 5 years ago
schoden , refer to page two of the attached file after Signature, I created a flag
amitchandak
Super User
5 years agoschoden , You can create year on date or using related
year = related(Date[Year])
Or
Year = Year([Date])
- schoden5 years ago
Post Partisan
amitchandak it still shows red line.