Get max version over Document Number

[Anonymous]

Hi,

I have a sample data as below and I would like to consider the record with max version over document number.

Expected Result set:

Appreciate for any quick help on this

[ibarrau]

Hi! you can just add Document number in a visualization (test it with table), if it's a data type number be sure to click on the arrow "Don't summarize". Then add version to the visualization and go to the arrow again but this time click on Max (it has to be a number/int data type).

That way you'll have the expected result.

Regards,

[Greg_Deckler · Accepted solution]

I agree with @ibarrau . If you want a new table, you can do this:

Table 2 = SUMMARIZE('Table',[Document Number],"Version",MAX('Table'[Version]))

[Anonymous]

Hi @ibarrau ,

I need only Document number and other columns in the Table graph for max version. (No need of version field in the table Graph)

it should be like the below,