Measure to count new ID per month
HI everyone, I am new user of Power BI and got stuck. Kindly need help! Here that I need for help from expert: 1. Measure: to identify or count the new ID per month as well as not counting the existing ID and filtered by "active student" 2. Measure: to count delete student per month. Here my sampel table, I named id "Table1" : Date ID Student Status Student 1 january 2021 1 Active 1 january 2021 2 Active 1 january 2021 3 Delete 1 january 2021 4 Delete 1 february 2021 5 active 1 february 2021 1 active 1 february 2021 2 active 1 march 2021 6 active 1 march 2021 7 active 1 march 2021 3 active I hope the final measure which are card for "add student" and "deleted student" Your prompt support will be really appreciated.