Return Column Header from MAX Date

[united2win]

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]

Hi @united2win,

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

Thanks & Regards,

B V S S

[united2win]

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]

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]

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]

Hi @united2win ,

Here i attached pbix file

Download this Pbix file 

Thanks & Regards,

B V S S

[Anonymous · Accepted solution]

Hi @united2win ,

Previous link is not working.. Here is updated one

Here

Thanks & Regards,

B V S S