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 sa...
Need Help
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] )
    )
)