Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AV_04
Helper I
Helper I

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
1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

I am not sure how the failed measure is written, but please check the below picture and the attached pbix file.

Jihwan_Kim_0-1678338725225.png

 

 

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.


Go to My LinkedIn Page


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.