Need help! Count ID after change in Status between previous Months

[hgzelaya]

Hello everyone, i'm currently trying to create a measure using count ids after status change. I created tthis table with the desired results im looking for.

ID	Month	Status
1	Jan-19	OK
2	Jan-19	OK
3	Jan-19	OK
4	Jan-19	OK
1	Feb19	Pending
2	Feb19	Pending
3	Feb19	OK
4	Feb19	OK
1	Mar-19	OK
2	Mar-19	Pending
3	Mar-19	Pending
4	Mar-19	OK
1	Apr-19	Pending
2	Apr-19	Pending
3	Apr-19	Pending
4	Apr-19	Pending

What i need is a graph showing me the amount of ids that changed from "ok" to "pending" in this example.

Desired Results in this Example
Feb-19	2
Mar-19	1
Apr-19	2

Drive : https://docs.google.com/spreadsheets/d/1avTU1EUpn3fs8wXYJ0X1Yc3Y4crs_ux-9fC90c9xwGE/edit#gid=0

[hgzelaya]

bump

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[hgzelaya]

---

@Ashish_Mathur wrote:

Hi,

You may download my PBI file from here.

Hope this helps.

---

Hello @Ashish_Mathur , it worked with the example i used however, will that same measure work with a data base with 110,000+ different ids?

[Ashish_Mathur]

Try that yourself.