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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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,

  • 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]))