Forum Discussion
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?
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
- MariuszCommunity 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- AnonymousNot 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!
- v-frfei-msftCommunity 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.