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                 ...
Need Help
Show and Tell
Tips and Tricks
  • 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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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
6 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
    6 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
      Helper III
      6 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