Forum Discussion
Conversions
Hi all, I have a table with Id, Destination, date columns I created three tables destination1 ,destination2 ,Ids Destination1= SUMMARIZE(FILTER('Table,'Table'[DESTINATION]<>blank()),'Table'[DEST...
amitchandak
could you suggest me how to find the frequency of the customer, like If the customer has the transactions once or more every 2 months? (count of the customer)
Try
Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),ALLEXCEPT('Table','Table'[Month-Year]))
New amount = CALCULATE(SUM('Table'[Amout]),VALUES('Table'[ID]),FILTER('Table',[Measure]>1))
If it do not resolve. Please create a new Message.