Forum Discussion
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 any quick help on this
I agree with ibarrau . If you want a new table, you can do this:
Table 2 = SUMMARIZE('Table',[Document Number],"Version",MAX('Table'[Version]))
3 Replies
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,
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,
I agree with ibarrau . If you want a new table, you can do this:
Table 2 = SUMMARIZE('Table',[Document Number],"Version",MAX('Table'[Version]))
