Forum Discussion
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.
- Anonymous6 years ago
6 Replies
- AnonymousNot applicable
Hi united2win,
What is your desired output in that column. Please post that also
Thanks & Regards,
B V S S
- united2winHelper 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)
- AnonymousNot 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