Forum Discussion
Checking for duplicates month on month
Hello Power bi community,
I hope everyone as well. I ned help regarding some issue that i have been facing. So I have this data for insurance policies where each policy buyer is renewing its policy in each month. I need to check how many policy buyer are carried forward each month from the previous month. Basically i want to divide my data between new business for the month and the renewal from the previous month to det the total business for that particular month. e.g
3 Replies
Hi Anonymous
Please show some sample data and explain what you need with an example based on it, showing the expected result
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
So lets say there is a customer ABC he buys a policy in september 2020 and renew the policy each month. Now lets consider i want to find the total business for october 2020. The total business would consist of new policy buyers in october 2020 and the policy holders of september who renewed there policy in october 2020. So i want to break my total business in terms of new policy issued and the renewed policy for each month.
Anonymous
1. Place DatesT[YearMonth] in a table visual
2. Place measures in the visual
New = VAR currentYM_ = SELECTEDVALUE ( DatesT[YearMonth] ) VAR c1_ = CALCULATE ( DISTINCTCOUNT ( Table1[CustID] ), DatesT[YearMonth] <= currentYM ) VAR c2_ = CALCULATE ( DISTINCTCOUNT ( Table1[CustID] ), DatesT[YearMonth] < currentYM ) RETURN c1_ - c2_Renewed = VAR currentYM_ = SELECTEDVALUE ( DatesT[YearMonth] ) VAR c1_ = CALCULATE ( DISTINCTCOUNT ( Table1[CustID] ), DatesT[YearMonth] = currentYM ) VAR c2_ = [New] RETURN c1_ - c2_Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
