Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get max version over Document Number

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

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

     

    Table 2 = SUMMARIZE('Table',[Document Number],"Version",MAX('Table'[Version]))
ibarrau's avatar
ibarrau
Super User
6 years ago

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's avatar
Greg_Deckler
Community Champion
6 years ago

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

 

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