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

[ascott]

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 ID and the MAX Utilization & MIN Utilization of that ID

 

[Phil_Seamark · Accepted solution]

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]

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