Not sure in which views you'll be using the calculation, but I've created a LOD using a combination of fixed and exclude:
The calculation is saying, for every deal ID + Deal name, tell me the maximum sync time. If the sync time matches against the max, show me the industry. The exclude LOD is there because the level of detail in the view has Sync Time and Industry, so would not popular all the fields.
Please see the attached workbook.
If this answers your question, please mark as correct to update this thread.
We would love to hear your feedback on your Tableau Community Forums experience.
Please take this 5 minute survey.
We appreciate your feedback,
Tableau Community Forums team
LOD calc.twbx 16.7 KB
this will find the last date
and this will find the industry on the last date
it returns this
but the issue is what happens if the last date industry is null
then you could try this
can't test it - don't have your twbx workbook with the data included
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.