Forum Discussion

jmetf150's avatar
jmetf150
Helper 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
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    jmetf150 You can use a Complex Selector for this. The Complex Selector - Microsoft Fabric Community

    Probably something like:

    Measure =
  VAR __PO = MAX('Table'[PO])
  VAR __CurrentDate = MAX('Table'[Confirmation Date])
  VAR __MaxDate = MAXX( FILTER( ALL('Table'), [PO] = __PO ), [Confirmation Date])
  VAR __Result = IF( __CurrentDate = __MaxDate, 1, 0 )
RETURN
  __Result
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    jmetf150 No, because they don't alphabetically sort correctly. So if you had AB, P2 and E1 and got the max, it would return P2. You could create a calculated column that assigned a number such as a SWITCH statement that assigned 1 to AB, 2 to P2, etc. and that should work in lieu of a date.

jmetf150's avatar
jmetf150
Helper 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
    Community 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