Forum Discussion

gadlakha's avatar
gadlakha
Frequent Visitor
3 years ago

DAX Query

Hi All, I have a table that lists the Release_IDs, Release_Versions, Release_Category, Release_BaseVersion and a flag to specify if a given release was external or not. ID Version Category Ba...
Need Help
gadlakha's avatar
gadlakha
Frequent Visitor
3 years ago

Hey. Can someone kindly help with this?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi gadlakha ,

 

Plese try this:

LastRelId = 
CALCULATE (
    MAX ( 'Table'[ID] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[isRelease] = TRUE ()
            && 'Table'[Category] = EARLIER ( 'Table'[Category] )
            && 'Table'[Base] = EARLIER ( 'Table'[Base] )
            && 'Table'[Index] <= EARLIER ( 'Table'[Index] )
    )
)

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum