Forum Discussion
Solved
Continous 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...
schoden , refer to page two of the attached file after Signature, I created a flag
schoden , Create a new column of the year first and try. Earlier will not allow quite a few options
amitchandak got the diff column running. But I am not able to acheive the outcome of my purpose.
Final measure =calculate(distinctcount(v_api_find_Opportunity[Company_RecID]) , filter(v_api_find_Opportunity, v_api_find_Opportunity[Diff]>1))
This measures return YEAR 2012 records only.