Forum Discussion
Count from the first seen
Hello My data header looks like this: Customer ID | Earliest seen date |Filter Date| I want to count the number of times a unique client has been detected.It should be based on the main dat...
Not able to get the problem you are facing.
If you add a slicer for filter date and select the count of customer id in visual.
The earliest seen date it is also a calculated measure
Earliest seen = CALCULATE(MAX('DATA Table'[Earliest Seen Date]),USERELATIONSHIP('DATA Table'[Earliest Seen Date_],'Table'[Date]))
where :
Earliest Seen Date_ = DATE(YEAR('DATA Table'[Earliest Seen Date]),MONTH('DATA Table'[Earliest Seen Date]),DAY('DATA Table'[Earliest Seen Date]))
Table Data it is a new table created by me with fy 20
i want to calculate the number of times a unique client has been detected from the earliest seen date in the date range selected