Forum Discussion

schoden's avatar
schoden
Post Partisan
5 years ago
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...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

schoden , Have a new column like this in you fact

Diff = [Year] - maxx(filter(Table,[customer] =earlier([customer]) && [Year] <earlier([Year])),[Year])

 

And then use a measure like

Measure = calculate(distinctcount(Table[Customer]) , filter(Table, Table[Diff]>1))

schoden's avatar
schoden
Post Partisan
5 years ago

amitchandak  I have Year from Calender table . 

If the new column is created in fact table, Year gets red underlined. 

How Can i refer year from calender table in the fact table.