Forum Discussion

united2win's avatar
united2win
Icon for Helper III rankHelper III
7 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                 ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi united2win ,

     

    Previous link is not working.. Here is updated one

     

    Here

     

     

    Thanks & Regards,

    B V S S

united2win's avatar
united2win
Icon for Helper III rankHelper III
7 years ago

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
7 years ago

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

  • united2win's avatar
    united2win
    Icon for Helper III rankHelper III
    7 years ago

    Hi,

     

    That's the issue, I'm fairly new to Power BI, so I don't really know what to use in the Calculated DAX formula. It's not like excel where I can copy and paste the formula (unfortunately)

     

    Alex

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi united2win ,

         

        Previous link is not working.. Here is updated one

         

        Here

         

         

        Thanks & Regards,

        B V S S