Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Switch If and Else to compare multiple months

Hello,

 

I am trying to use if or switch logic to complete the folllowing. I work for a collections call center and customers will roll throught these things we call buckets if they become delinquent or they will "cure" if they pay off the loan.

 

I created quick measures to compare each year to the previous. However, the method I chose to use is creating a new column and creating duplicate customers (loan_num) for march (I circled an example in blue).

 

I want to be able to compare there statuses for the three months without March creating a new row, which is causing what I wrote below to be innacurate. 

 

Any takers on what I can do to improve this logic?

 

 

  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    You can create measures "collected" and "cure".

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

7 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion

    Hi   Anonymous

     

    Sorry if I miss understood your requirement, but the extra row is introduced by adding CCR to your Table visual, so once removed it will not add an extra row.


    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello,

       

      Yup that was what it was. That new column is creating duplicates. Unfortunatly, I need the calculations for the next visual so that we can see how many loans "collected", "cure", or remained delinquent. Do you have any suggestions on the best way to do this?

       

      Thanks for taking a look at this! I have been working on this for a week!

      • Mariusz's avatar
        Mariusz
        Community Champion

        Hi Anonymous 

         

        You can create measures "collected" and "cure".

         

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        LinkedIn

         

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi Anonymous ,

     

    Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.