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