Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

help with Summarize

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

    Anonymous 

     

    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

sanalytics's avatar
sanalytics
Icon for Super User rankSuper User
4 years ago

Anonymous 

 

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

 

Regards

sanalytics

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.