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

 

 

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

6 Replies

  • sanalytics's avatar
    sanalytics
    Super 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
        Super User
        4 years ago

        Anonymous 

         

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

         

        Regards

        sanalytics