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
Super 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
    Super User
    4 years ago

    Anonymous 

    Please provide some dummy data to work on..

     

    Regards

    sanalytics

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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