cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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.

IDMonthStatus
1Jan-19OK
2Jan-19OK
3Jan-19OK
4Jan-19OK
1Feb19Pending
2Feb19Pending
3Feb19OK
4Feb19OK
1Mar-19OK
2Mar-19Pending
3Mar-19Pending
4Mar-19OK
1Apr-19Pending
2Apr-19Pending
3Apr-19Pending
4Apr-19Pending

 

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-192
Mar-191
Apr-192

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

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

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Highlighted
Helper I
Helper I

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

bump

Highlighted
Super User IV
Super User IV

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

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Highlighted
Helper I
Helper I

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

 


@Ashish_Mathur wrote:

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


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?

Highlighted
Super User IV
Super User IV

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

Try that yourself.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors