filter column

[Omar8787]

Dear all,

I need your support in writing a DAX formula.

Situation
I have a table containing a column "PurchaseOrderDocumentReference" there are several confirmations in each Purchase Order. So, I want to filter the latest confirmation of the column. How to do that?

Best Regard

[Migasuke]

@Omar8787,

can you give more info? For example, why do you have highlighted some numbers in your screenshot or do you have any date, we could use?

[Omar8787]

my highlight is an example of how the PO number duplicates and the difference is only the last digit of each rows

[Migasuke]

So if I understand well:
You want to filter purchase orders with the highest number at the end? So for example: PO-00000-3 and PO-00010-3?

[Omar8787]

Yes, Correct 

[Migasuke · Accepted solution]

Okay,

Now it depends if you need calculated column or measure, but I will cover both.
1. You need to create new column, where you extract the last digit. So you should have two columns. One with only pure PO and second with "version":

The best way how to do this is in Power Query, for example with extract options:

2. Once you have your two columns, you can create conditional DAX column, which defines last version. Formula looks like this:

At this point, you can use this column for filtering you report. You just need to check "Latest".

3. In case you want to create a measure, you can now use this column for measures. Let's say each of my order has also value. If we want to sum value only for latest PO, we can do it:
Last Value for POs = CALCULATE(SUM('Table'[Value]),'Table'[Last Version] = "Latest")