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.

       

       

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

        Anonymous 

        Please provide some dummy data to work on..

         

        Regards

        sanalytics