Forum Discussion

AV_04's avatar
AV_04
Helper I
3 years ago

Power BI Dax request

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.

PositionCodeUnitsAvailableFilled
A1400.51
A200.50
B1200.50.5
B2200.50.5
AZ4011
BZ4011
Need Help

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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] )
    )
)