help with Summarize

[Stubby]

Hi All

Please can I have some help with the following:

I have the following DAX creating a table that is pulling Item from the main items table. As you can see from the screen shot below some items have had multiple revisions. How do I create a table that shows the highest revision number. so in the table below i would like to only see revision 20.0

Any help would be much appreciated.

[sanalytics · Accepted solution]

@Stubby 

Can you try 
summarize(les_items_data,les_items_data[item_id],les_items_data[Tile],"Max Revison",Max(les_items_data[Revision_Number] ) )

and let us know if it works or not.

Regards

sanalytics

if it is your solution then please like and accept it as your solution

[Stubby]

Hi sanalytics

yes that did work if I took out the Title element which changed on each revision.

Many thanks

[sanalytics]

@Stubby 

Glad it works..Much appreciate if you provide kudos.

Regards

sanalytics

[Stubby]

I've Kudos your last post 😁

Could I ask for a little more help!

by applying your solution i get the following result

I gather the summarize is saying each of the titles is unique hence why they are showing. I only want to show the Title with MaxRevision 20 (in this example). My ulitimate goal is to have a table that shows the most recent Item Title for each Item_id.

[sanalytics]

@Stubby 

Please provide some dummy data to work on..

Regards

sanalytics

[Stubby]

Thanks for the reply. Since posting the database owner has changed his requirements and no longer requires what I am trying to achieve. Your initial help was much appreciated though