Forum Discussion
Find the acc missing and newly added
Hi v-jianboli-msft;
Thanks for the solution the thing is I have find the count of accounts missing and added. How do I change the DAX.
and the other thing is
| R_Date | Acc | Source | F_P |
| 07/01/2022 12:00AM | 1234 | C | 1 |
| 07/01/2022 12:00AM | 1235 | C | 2 |
| 07/01/2022 12:00AM | 1233 | B | 2 |
| 08/01/2022 12:00AM | 1233 | B | 2 |
| 08/01/2022 12:00AM | 1234 | C | 2 |
| 08/01/2022 12:00AM | 1235 | C | 1 |
Hi v-jianboli-msft ,
quick question on finding missing and added accounts.
I have an other column called F_P that says whether the account is active or deactivated or newly added. I want to change the formula accordingly.
For example, above table has an account 1234 in both july and august. But in July the F_P is 1 which means there is one account. but in august they have 2 so one is added that goes into new activation and 1 is base.
other example, 1235 in July F_P is 2 which means one account with two different products(phone/tv connection) where as F_P in august is 1 which means the account has deactivated some connection which goes into deact.
Please Help