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 

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