Forum Discussion

jmetf150's avatar
jmetf150
Icon for Helper I rankHelper I
2 years ago
Solved

Only Display Latest Sequence

Goodday - I am looking for the DAX code/formula I can use to do the following.  I have a list of Open PO numbers.  Each open PO can have up to 9 different confirmation types.  Each confirmation type ...
Show Only Latest Sequence
jmetf150's avatar
jmetf150
Icon for Helper I rankHelper I
2 years ago

Greg_Deckler forgot I already had a column that told me the sequence number for that line so just modified the "date" to the "confirmation sequence number" and filtered to only show me "1" and it worked. 

 

Now, how would I apply that meansure to a card?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    jmetf150 Well, that's a bit tricky TBH as I am not sure what you are trying to display in that card. But, if you have that Measure, you could do this:

    Card Measure = 
  VAR __Table = ADDCOLUMNS('Table', "__Measure", [Measure])
  VAR __Row = FILTER(__Table, [__Measure] = 1)
  VAR __ConfirmationType = MAXX( __Row, [Confirmation Type])
RETURN
  __ConfirmationType