Forum Discussion

united2win's avatar
united2win
Helper III
6 years ago
Solved

Return Column Header from MAX Date

Hi,

 

I have the below table: I will need to add a column to reflect the status from a number dates

 

Service:                              Country:                 Pack to Agent                     Pack to Client                         New Column: Service Status

VAT Registration               Germany                     15/02/2019                      30/02/2019                                            Pack to Client

VAT Registration               Spain                           14/02/2019                      02/01/2019                                            Pack to Agent

VAT Registration               UK                               16/03/2019                      16/03/2019                                                       *?

 

*? What would happen if the dates are the same?

 

Any help will be greatly appreciated.

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi united2win ,

     

    Previous link is not working.. Here is updated one

     

    Here

     

     

    Thanks & Regards,

    B V S S

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi united2win,

     

    What is your desired output in that column. Please post that also

     

    Thanks & Regards,

    B V S S

    • united2win's avatar
      united2win
      Helper III

      Aplogises, there's a formatting error:

       

      The new column would like this:

       

      Service Status:

       

      Pack Sent to Client

       

      Pack Sent to Agent

       

      Pack Sent to Client (This would take preference if the dates were the same)

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi united2win ,

         

        Please try  if (or condition in your calculated column dax.. otherwise please send your calculated column formula i will modify it. Because i don't have system to try this

         

        Thanks & Regards,

        B V S S