Forum Discussion

ascott's avatar
ascott
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Distinct Assets with MAX and MIN Utilization in a new Table Summarized

I am trying to create a new table from an existing table with Distinct Unique ID's that shows the MAX Utilization & MIN Utilization of each ID.    The new table should have only 2 entries for each ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi ascott

     

    If you create a calculated table in DAX you should be able to get what you need.

     

     

    New Calculated Table = 
    SUMMARIZE (
        'YourTableName' , 
        [ID] ,
        "Max of Utilization" , MAX([Utilization]) ,
        "Mim of Utilization" , MIN([Utilization]) 
        )

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ascott

 

If you create a calculated table in DAX you should be able to get what you need.

 

 

New Calculated Table = 
    SUMMARIZE (
        'YourTableName' , 
        [ID] ,
        "Max of Utilization" , MAX([Utilization]) ,
        "Mim of Utilization" , MIN([Utilization]) 
        )

 

ascott's avatar
ascott
Icon for Advocate II rankAdvocate II
8 years ago

I can't say how many times I tried to do that and it failed each time. I copied your code over mine and of course changed the table names and it works. 

Now to the finer details. I might hit you back with another question if I get stumped. 

Thanks for the quick repsonse to my question.

 

Regards,

Andy