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.

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

Hi,  Anonymous 

 

Can you explain the logic of active and inactive? Is it inactive if you don’t place an order on the same day?

Secondly, Can you share some more sample fake data? So we can quickly help you deal with the problem.

 

Best Regards

Janey Guo

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Here is my current setup in PBI file and then I made a chart for what I am looking for. Active is if you placed an order in the last 100 days but I want to be able to see it historically instead of how I have it currently which is just off of today()

PBI File 

 

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

    Hi,  Anonymous 

     

    I'm sorry that monday is too busy, no time to reply. I see that your problem changes every time, it is difficult for me to understand what you are asking for.

    I try to understand the requirements you described last time: Do you need to distinguish between active customers and inactive customers based on month and whether the date of the customer's last order is more than 100 days? Then I want to ask, there are different years in your date, how do you distinguish it? And if the user places an order in the current month, but the last order date has changed, shouldn’t it be counted in the current month?

    Calculation is not difficult, but a complete logic is necessary before I can calculate. Can you explain more clearly?

     

    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