Forum Discussion

cdawidow's avatar
cdawidow
Icon for Helper III rankHelper III
4 years ago

LASTDATE Not working as required

Hi guys, I am trying to retrieve the most recent QTY On Hand for each product in my inventory but the trouble I am having is that for whatever reason, some of these products can be present on multipl...
DAX
Help Requested
LastDate
LASTNONBLANK
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi cdawidow 

 

Try this:

LAST INVENTORY VALUE =
VAR X =
    CALCULATE (
        MAX ( INTRAN00[TXQOH] ),
        FILTER (
            INTRAN00,
            INTRAN00[TXTIME] = MAX ( INTRAN00[TXTIME] )
                && INTRAN00[TXLINE] = MAX ( INTRAN00[TXLINE] )
        )
    )
RETURN
    X

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!