The TREATAS Function

[Anonymous]

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 for calculations and it works great for me, but not for just pulling out data from a specific record.

if it can't be done what would be an alternative?  The tables are not linked and they won't be.
Thanks.

[PaulDBrown]

Try:

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

[Anonymous · Accepted solution]

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]

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]

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!

[Anonymous]

whatever value is in this field, i want to show the value.
In the function lookupValue you can do a lookup . I'm looking to do the same thing with TreatAs.  

Does that help?

[Anonymous]

Hi , amitchandak.  I want to get whatever value is in the Epic Actual Start Date. Something like a lookup.
Every example of Treatas I've seen, uses a calculation
But what if you just want to get the value in a specific field?

[amitchandak]

@Anonymous , Treatas will allow you filter the column across table.

Can you explain what do mean by get the date