Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hgzelaya
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

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
hgzelaya
Helper I
Helper I

bump

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/

 


@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?

Try that yourself.


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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.