Forum Discussion

a-simarg's avatar
a-simarg
Helper II
6 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Do you want two date filters?

If yes. This is bit different but on the same line Comparing-Data-Across-Date-Ranges

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

a-simarg's avatar
a-simarg
Helper II
6 years ago

Hi amitchandak 

 

i would like to use only a single date filter and that one to be "Filter date"

 

Thanks

Simona

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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.

    • a-simarg's avatar
      a-simarg
      Helper II
      6 years ago

      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