Forum Discussion

cherimjewell67's avatar
cherimjewell67
Frequent Visitor
2 years ago

Churn Counts Not Working

I'm trying to create a formula for a count of customers where the prior month revenue is >0 and current month revenue is =0. I've tried so many iterations of the same formula I'm seeing stars. I h...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi cherimjewell67 ,

I’d like to acknowledge the valuable input provided by lbendlin . His initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.  

In my investigation, I took the following steps:

I create a table as you mentioned.

I think you can use IF function.

Status =
IF (
    'Orders'[Differences] = 0,
    "NO CHANGE",
    IF ( 'Orders'[Current] = 0, "CANCEL", "DOWNGRADE" )
)

 

 

 

Best Regards

Yilong Zhou

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

cherimjewell67's avatar
cherimjewell67
Frequent Visitor
2 years ago

I appreciate these responses, however, I'm trying to count the results of each status by month. Here's what the statuses look like: 

Image A

Here's what I need to create.

Image B

Thank you for all your help!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi cherimjewell67 ,

    It looks like there are a lot of unknowns in your .pbix file, could you please upload your .pbix file or more key information for me to research deeper?

     

     

    Best Regards

    Yilong Zhou

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