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.

Singaravelu_R's avatar
Singaravelu_R
Icon for Resolver III rankResolver III
5 years ago

Add the calculated column in the customer table

Active or In active customer = if (DATEDIFF(today(),last order date())=100,  "Active Customer","Inactive Customer")

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Don't think this would give me historical view of how many active and unactiave I have

  • 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.