Count previous rows in table with same user ID

Hi, I'm looking for a way to filter my datasource based on whether a customer is appearing in the table for the first time. A simplified version of the table would look something like this: ...

Need Help

Sean

9 years ago

mahawkins3

You can create a Column like this

New Column =
IF (
    'Table'[Date]
        = CALCULATE (
            FIRSTDATE ( 'Table'[Date] ),
            ALLEXCEPT ( 'Table', 'Table'[User_ID] )
        ),
    1,
    0
)

Hope this helps! :smileyhappy:

Forum Discussion

Count previous rows in table with same user ID

Related content

Count previous months

Counting nulls

How to get Count from two different table- Un-match Count Table Record with New Table

Count of previous week

How to Count from two different table Un-matched record with New table