How to Return the Latest Revisions only for Each Document

[TestsUK]

Hi All,
Good day..!
May I ask how can I return only latest revision of document:

This function defines all revisions and returns them in the table above. But I want to exclude all previous revision (A00, A01, A02) and to show only latest (A03):

LatestRevision =

CALCULATE(

    MAX('Aconex Workflow'[DocumentRevision]),

    FILTER(

        ALL('Aconex Workflow'),

        'Aconex Workflow'[DocumentNumber] =

            MAXX(

                FILTER('Aconex Workflow', 'Aconex Workflow'[DocumentNumber] <> BLANK()),

                'Aconex Workflow'[DocumentNumber]

            )

        && 'Aconex Workflow'[DocumentRevision] =

            MAX('Aconex Workflow'[DocumentRevision])

    ))

[Ashish_Mathur]

Hi,

Do you want a Query Editor solution or a DAX measure solution.  Also, share data in a format that can be pasted in an MS Excel file and show the expected result.

[Kishore_KVN]

Hello @TestsUK ,

Creating new column using that revision column, using below DAX

Version number = Right(Latest_Version,2) and change its data type to whole number. 

Then create you MAXX calculation on that column. 

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

[TestsUK]

Hello 

Is returns an error when i try change data type.