Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Requesting your help on the below requirement.
In the below table I have the following columns, below are the conditions:
for a particular position, there would be three codes say 1,2 and Z. If code =1 and code=2 and units < 21, then filled is 0.5,
if code = 1 and units >21 and code =2 is null, then filled is 1,
if code=Z, filled =1
I can do the above thing in switch, but unable to add in the filter for finding the earlier of position i.e to find the filled for a particular position of say A since they may be placed anywhere. something like (table[position] = earlier(table[position])
Please requesting your help in this.
Position | Code | Units | Available | Filled |
A | 1 | 40 | 0.5 | 1 |
A | 2 | 0 | 0.5 | 0 |
B | 1 | 20 | 0.5 | 0.5 |
B | 2 | 20 | 0.5 | 0.5 |
A | Z | 40 | 1 | 1 |
B | Z | 40 | 1 | 1 |
Hi,
I am not sure how the failed measure is written, but please check the below picture and the attached pbix file.
Earlier position measure: =
CALCULATE (
[Failed measure:],
OFFSET (
-1,
ALL ( Data[Position], Data[Code], Data[Available], Data[Units] ),
ORDERBY ( Data[Code], ASC ),
KEEP,
PARTITIONBY ( Data[Position] )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |