Forum Discussion

ivancans's avatar
ivancans
Frequent Visitor
8 years ago
Solved

MAX date for an ID with repeating dates

Hello,   I would like to get your help in the following matter. I have ID's with multiple dates. I need to return latest date for each of the ID's and compare the result with the specific row. If t...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    ivancans

     

    Sorry I was out of office

     

    In Query Editor, you can use Group By Function to get the Max Dates for each ID

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

ivancans

 

You could also use DAX calculated column

 

Max Date =
CALCULATE (
    MAX ( Table1[Date Hour and Minutes] ),
    ALLEXCEPT ( Table1, Table1[Application ID] )
)
ivancans's avatar
ivancans
Frequent Visitor
8 years ago

Thanks Zubair_Muhammad but I thought that it is better to do it in query mode because it is somehow less hardware demanding procedure. Am I wrong on this one?

  • ivancans's avatar
    ivancans
    Frequent Visitor
    8 years ago

    Also, how can I filter out ture ones in data view so that the table becomes uniqe in relationship view. I did filter out the value but I still couldn't create relationship. See screens attached.  

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      8 years ago

      ivancans

       

      Sorry I was out of office

       

      In Query Editor, you can use Group By Function to get the Max Dates for each ID

       

      • ivancans's avatar
        ivancans
        Frequent Visitor
        8 years ago

        Thank you Zubair_Muhammad ! I actually stumbled upon this solution half an hour ago, but nontheless this seems to be the right solution! :smileyhappy: