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

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