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!

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Not 100% sure how you want to materialise the "answer" but something like this:

VAR SelectedFomattedID = VALUES( RallyEpics[Formatted ID] )

VAR Result =
	CALCULATE (
		SELECTEDVALUE ( 'WIP Data'[Epic Actual Start Date], "More than one value" ),
		TREATAS ( SelectedFormattedID, 'WIP Data'[Epic ID] )
		)

RETURN Result
Anonymous's avatar
Anonymous
Not applicable
4 years ago

bcdobbs, that was exactly what i want to do. I was a bit confused because of the initial portion of the TREATAS functionality. But that basically worked!