Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Active Customers by day

I currently count active and unactive customers based on customers who have been in +/- 100 days. My measures only give me a current day view of the active customers. Would it be possible to get a me...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    I'm sorry. I modify the measure.

    active = 
COUNTX (
    FILTER (
        ALL ( Customers ),
        Customers[CURRENT last order]
            >= SELECTEDVALUE ( 'Table'[Date] ) - 100
            && [CURRENT last order] <= SELECTEDVALUE ( 'Table'[Date] )
    ),
    [customerID]
) + 0
    inactive = 
COUNTX (
    FILTER (
        ALL ( Customers ),
        Customers[CURRENT last order]
            < SELECTEDVALUE ( 'Table'[Date] ) - 100
            || [CURRENT last order] > SELECTEDVALUE ( 'Table'[Date] )
    ),
    [customerID]
) + 0

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I would just want the formula using my datekey so I could pick and date in history and it do a 100 look back at active customers. For example if I put in 3/1/2021 it would just look at 3/1/2021 and minus 100 days to see who was active. It would ignore customer orders 3/2/2021 to today. 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi,  Anonymous  

 

According to your description, You want to choose a date. If a customer has an order within 100 days of this date, then he is an active user, right?

But there is only month in this table, it will generate the question I replied last time, so what is the final result you want? How to achieve it is not difficult, as long as you are sure what you want.

Best Regards

Janey Guo

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    instead of month think of it as 1/31/2021, 2/28/2021, etc