Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Countif for duplicate values

Hi, Simple question, I suppose. I have 2 columns. A: unique bookingID B: customerID for those bookings   In column C I would like to see how often customerID occurs from column B; often that cu...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,

    new columns

    Count across booking ID

    countx(filter(table ,[Customer ID] =earlier([Customer ID])),[Customer ID])

     

    Count across within  booking ID

    countx(filter(table ,[Customer ID] =earlier([Customer ID]) && [Booking ID] =earlier([Booking ID])),[Customer ID])

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,

new columns

Count across booking ID

countx(filter(table ,[Customer ID] =earlier([Customer ID])),[Customer ID])

 

Count across within  booking ID

countx(filter(table ,[Customer ID] =earlier([Customer ID]) && [Booking ID] =earlier([Booking ID])),[Customer ID])