Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Team ,
Following is my raw data table
Revision | Document no | Islatest | State |
12 | A | FALSE | released |
15 | A | FALSE | released |
20 | A | FALSE | retired |
31 | A | TRUE | released |
12 | B | FALSE | retired |
43 | B | FALSE | work in progress |
55 | B | TRUE | work in progress |
So i have to create a measure which will help me show visualization in powerbi report
I have to check if the current document which has the largest revision ID and which is latest column is True , should be either work in progress or should be released
but if there is a document of which revision is not the largest and it is not the latest then it should be released first and then the higher revision id document work should be started .
for example the last two rows can be seen that the revision id 43 is still work in progress and it is not even latest but still not released hence we should make a measure which will show in next column using measure as shown below,
Revision | Document no | Islatest | State | Overlap |
12 | A | FALSE | released | no |
15 | A | FALSE | released | no |
20 | A | FALSE | retired | no |
31 | A | TRUE | released | no |
12 | B | FALSE | retired | no |
43 | B | FALSE | work in progress | yes |
55 | B | TRUE | work in progress | latest but overlap with last revision |
that means the latest largest revision must be only in work in progress if the earlier row is released . if the earlier row is not released it is still work in progress then measure should flag them as shown above
please ask questions if anything is not clear any help is appreciated
please help
Solved! Go to Solution.
i got this solved thanks . I used this
flag = i entered yes for all the last projects which had maximum rev id
i got this solved thanks . I used this
flag = i entered yes for all the last projects which had maximum rev id
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |