Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
bump
Hi,
You may download my PBI file from here.
Hope this helps.
@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?
Try that yourself.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |