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 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi sanalytics

     

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

     

    Many thanks

     

    • 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.