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

 

 

 

 

 

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]) 
        )

     

2 Replies

  • 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