Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

The TREATAS Function

Hi, I see alot of examples of TREATAS, with calculations,  but I'm trying to get a specific value from a table. How would I get the date below, using the TREATAS function?   I see the function used ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks Paul. I'll give it a try.  I had trouble with the first portion of the TREATAS function.
    In the first portion, the MAX(WIP Data[Epic Actual Start Date])
    I see that's how you get a single record.  Thank you!

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Try:

epic start date = CALCULATE(MAX(WIP Data[Epic Actual Start Date]), TREATAS(VALUES(Rally Epics[Formatted ID]), WIP Data[Epic ID]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Paul. I'll give it a try.  I had trouble with the first portion of the TREATAS function.
    In the first portion, the MAX(WIP Data[Epic Actual Start Date])
    I see that's how you get a single record.  Thank you!